Current executing statements
Columns
| Name |
Description |
| Session ID |
Session ID |
| Elapsed Time |
Elapsed time |
| CPU Time |
CPU time |
| Login |
Login name |
| Logical IO |
Delta number of logical reads +
Delta number of physical writes |
| Physical IO |
Delta number of physical reads +
Delta number of physical writes |
| Database |
Database name |
| Start Time |
Start time of the statement |
| Program Name |
Name of client program |
| Logical Reads |
Number of logical reads |
| Physical Reads |
Number of physical reads |
| Physical Writes |
Number of physical writes |
| Cache Miss % |
Data cache miss %, or how often logical reads required physical reads |
| SQLID |
SQL ID; created by Surveillance (based on SQL handle) |
| SQL Text |
SQL text preview |
| Request ID |
Request ID |
Entity Requirements
| Attributes: |
DMV |
| Minimum database version: |
9.0 |
