Processes
Comments
System processes are shown under the tab Other Proccesses.
User Processes - Columns
| Name |
Description |
| Inst ID |
Instance ID; 0 = non-CE |
| SPID |
Session process ID |
| Login |
Login name |
| Program |
Application name |
| CPU % (one engine) |
CPU % Used (1 CPU) |
| Logical IO |
Delta number of physical writes +
Delta number of logical reads |
| Total Logical IOs |
Number of logical I/O operations |
| Logical Cluster Name |
Logical cluster name, if Cluster Edition |
| Memory |
Memory usage |
| Total Connect Time |
Duration of time connected |
| Total CPU Time |
CPU time |
| Total Wait Time |
Wait time |
| Cur Wait Event ID |
Wait event ID |
| Current Wait Event |
Wait event description |
| Current Wait Time |
Duration of time waiting |
| Blocked By |
Blocker session process ID (SPID), if applicable |
| Locks Held |
Number of locks held by this process |
| Logical Reads |
Number of logical reads |
| Physical Reads |
Number of physical reads |
| Physical Writes |
Number of physical writes |
| ULC Bytes Written |
Number of bytes written to the user log cache (ULC) for the process |
| Table Accesses |
Number of pages read without an index |
| Index Accesses |
Number of pages read with an index |
| TempDB Accesses |
Total number of temp tables created (including dropped ones) |
| Transactions |
Number of transactions started (including finished ones) |
| Commits |
Number of commits |
| Rollbacks |
Number of rollbacks |
| Status |
Process status:
- alarm sleep
- background
- infected
- latch sleep
- lock sleep
- PLC sleep
- recv sleep
- remote i/o
- runnable
- running
- send sleep
- sleeping
- stopped
- sync sleep
|
| Family ID |
Session process ID (SPID) of the parent process, if this is a worker process (for parallel query) |
| Batch ID |
Batch ID |
| Engine # |
Engine ID |
| Database |
Database name |
| TempDB |
TempDB name |
| TempDB Used |
Current TempDB space used |
| Command |
General command type |
| Set Client Name |
Client name |
| Set Client Application |
Client application name |
| Set Client Host |
Client host name |
| Host |
Host name |
| IP Address |
Client IP address |
| Client OS PID |
Client OS PID |
| KPID |
Kernel process ID |
Other Processes - Columns
| Name |
Description |
| Inst ID |
Instance ID; 0 = non-CE |
| SPID |
Session process ID |
| Command |
General command type |
| CPU % (one engine) |
CPU % Used (1 CPU) |
| Logical IO |
Delta number of physical writes +
Delta number of logical reads |
| Total Logical IOs |
Number of logical I/O operations |
| Memory |
Memory usage |
| Total Connect Time |
Duration of time connected |
| Total CPU Time |
CPU time |
| Total Wait Time |
Wait time |
| Cur Wait Event ID |
Wait event ID |
| Current Wait Event |
Wait event description |
| Current Wait Time |
Duration of time waiting |
| Blocked By |
Blocker session process ID (SPID), if applicable |
| Locks Held |
Number of locks held by this process |
| Logical Reads |
Number of logical reads |
| Physical Reads |
Number of physical reads |
| Physical Writes |
Number of physical writes |
| ULC Bytes Written |
Number of bytes written to the user log cache (ULC) for the process |
| Table Accesses |
Number of pages read without an index |
| Index Accesses |
Number of pages read with an index |
| TempDB Accesses |
Total number of temp tables created (including dropped ones) |
| Transactions |
Number of transactions started (including finished ones) |
| Commits |
Number of commits |
| Rollbacks |
Number of rollbacks |
| Status |
Process status:
- alarm sleep
- background
- infected
- latch sleep
- lock sleep
- PLC sleep
- recv sleep
- remote i/o
- runnable
- running
- send sleep
- sleeping
- stopped
- sync sleep
|
| Family ID |
Session process ID (SPID) of the parent process, if this is a worker process (for parallel query) |
| Batch ID |
Batch ID |
| Engine # |
Engine ID |
| Database |
Database name |
| TempDB |
TempDB name |
| TempDB Used |
Current TempDB space used |
| Logical Cluster Name |
Logical cluster name, if Cluster Edition |
| Login |
Login name |
| Program |
Application name |
| Set Client Name |
Client name |
| Set Client Application |
Client application name |
| Set Client Host |
Client host name |
| Host |
Host name |
| IP Address |
Client IP address |
| Client OS PID |
Client OS PID |
| KPID |
Kernel process ID |
SQL Plan Details - Columns
| Name |
Description |
| ID |
ID of this node in the plan |
| Parent ID |
ID of parent of this node in the plan; 0 = this node is the root node in the plan |
| Operation |
Name of operation for this node |
| Options |
Options for the operation for this node |
| Object |
Target object of this operation |
| Object2 |
Second target object of this operation |
| IO Size Data Pages |
I/O size used for data pages for this node |
| BRS Data Pages |
Buffer Replacement Strategy used for data pages for this node |
| IO Size Index Leaf Pages |
I/O size used for index leaf pages for this node |
| BRS Index Leaves |
Buffer Replacement Strategy used for index leaf pages for this node |
Procedure Stack - Columns
| Name |
Description |
| Inst ID |
Instance ID; 0 = non-CE |
| SPID |
Session process ID |
| Context ID |
Current context ID of the procedure |
| Stmt # |
Current statement number (unique in a batch) of the procedure |
| Type |
Type of procedure (stored procedure, etc.) in the stack |
| Object |
Name of the procedure in the stack |
| Line # |
Current line number of the procedure |
| Compile Time |
Compile date of the procedure |
| Owner |
Name of the owner of the procedure |
| Database |
Name of the database that contains the procedure |
| Memory |
Memory usage |
Entity Requirements
| Attributes: |
MDA |
| Minimum database version: |
12.5.0.3 |