SQL Server On Linux – OS Processes

Background

Let us review which OS Processes underpins SQL Server when running on a Linux Server.

Outline

  1. OS Tools
    • Services
      • systemctl
    • Processes
      • ps

 

Processing

OS Tools

Services

systemctl

Sample

sudo systemctl restart mssql-server.service

Output

osProcesses.20181128.0641PM

Example
  1. Process
    • Process Count :- 2

 

Processes

ps

Sample

ps -eo pid,ni,pri,psr,pcpu,stat,wchan:40,comm | grep sql
Output

ps.20181128.0656PM

Example
  1. Process
    • Process Count :- 2

Summary

In SQL Server for Linux :-

  1. SQL Server Agent
    • built into engine and does it not run wholly in its own process/address space
    • Only Supports SQL payload
  2. Edition
    • Edition :- Developer
      • Teletype is always running as its own process, can not be disabled

One thought on “SQL Server On Linux – OS Processes

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s