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 1-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. |