SQL Server Process
The MSSQL_Process class represents SQL Server processes. Note that these are not the same as an operating system's notion of a process. These are the processes identified by the SQL Server and assigned a SQL Server process ID by the SQL Server.
Default Collection Interval — Every 15 minutes
Table 2-69 SQL Server Process Metrics
| Metric | Description and User Action |
|---|---|
|
Process Handle (key column) |
Process ID. |
|
Blocked Process ID |
ID of a process being blocked by the process. |
|
CPU Time (ms) |
Cumulative CPU usage time of the process. |
|
Client Name |
Name of the client application. |
|
Command |
Abbreviated indicator of the current command. When no command is current, it has a value of AWAITING COMMAND. |
|
Creation Date |
Time that the process began executing. |
|
Database Name |
Database currently being used by the process. |
|
Execution State |
Current operating condition of the process. Possible values are as shown:
|
|
Host Name |
Name of the client workstation that started the SQL Server process. |
|
Login |
Login used by the process to connect to the SQL Server. |
|
Memory Usage (pages) |
Number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process. |
|
Process State |
Whether the process is running or sleeping. |
|
OS Level Thread ID |
Identifier of the OS level thread. |