Current executing statements
(session_id, request_id, start_time)
| Name | Data Type | Description |
|---|---|---|
| session_id | long | Session ID |
| request_id | long | Request ID |
| sqlid | string(36) | SQL ID; created by Surveillance (based on SQL handle) |
| planid | string(20) | SQL plan ID; created by Surveillance (based on SQL plan handle) |
| login_name | string(260) | Login name |
| program_name | string(260) | Name of client program |
| db_name | string(260) | Database name |
| start_time | time | Start time of the statement |
| elapsed_time_ms | long | Elapsed time, in milliseconds |
| cpu_time_ms | long | CPU time, in milliseconds |
| physical_reads | double | Number of physical reads |
| logical_reads | double | Number of logical reads |
| cache_miss_pct | double | Data cache miss %, or how often logical reads required physical reads |
| physical_writes | double | Number of physical writes |
| sql_text | string(1028) | SQL text preview |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| PHYSICAL_READS_DELTA | double | Delta number of physical reads |
| PHYSICAL_READS_TOTAL | double | Total number of physical reads, since collection started |
| LOGICAL_READS_DELTA | double | Delta number of logical reads |
| LOGICAL_READS_TOTAL | double | Total number of logical reads, since collection started |
| PHYSICAL_WRITES_DELTA | double | Delta number of physical writes |
| PHYSICAL_WRITES_TOTAL | double | Total number of physical writes, since collection started |
| CPUTIMEMS_DELTA | double | CPU time delta, in milliseconds |
| ELAPSEDTIMEMS_DELTA | double | Elapsed time delta, in milliseconds |
| Attributes: | DMV |
|---|---|
| Minimum database version: | 9.0 |