Current executing statements
(SPID, KPID, KEYID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| SPID | long | Session process ID |
| KPID | long | Kernel process ID |
| DBID | long | Database ID |
| PROCEDUREID | long | Procedure ID; 0 = not a procedure |
| BATCHID | long | Batch ID |
| CONTEXTID | long | Context ID |
| LINENUMBER | long | Line number in the batch |
| KEYID | string(72) | Internal-use, surrogate partial key; created by Surveillance |
| SQLID | string(20) | SQL ID; created by Surveillance |
| CPUTIME | long | CPU time, in milliseconds |
| WAITTIME | long | Wait time, in milliseconds |
| STARTTIME | time | Start time of statement |
| MEMUSAGEKB | long | Memory usage, in kilobytes |
| PHYSICALREADS | double | Number of physical reads |
| LOGICALREADS | double | Number of logical reads |
| PAGESMODIFIED | double | Number of pages written |
| PACKETSSENT | long | Number of network packets sent |
| PACKETSRECEIVED | long | Number of network packets received |
| NETWORKPACKETSIZE | long | Size of each network packet, in bytes |
| PLANSALTERED | long | Number of plans altered |
| ROWSAFFECTED | long | Number of rows affected |
| ELAPSEDTIME | long | Elapsed time, in seconds |
| ELAPSEDTIMEMS | long | Elapsed time, in milliseconds |
| MEMUSAGEB | double | Memory usage, in bytes |
| SQLTEXT | string(256) | SQL text preview |
| PROCEDURENAME | string(64) | Procedure name, if applicable |
| LOGIN | string(32) | User login name |
| DBNAME | string(32) | Database name |
| TEMPDBNAME | string(32) | TempDB name |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| WAITTIME_DELTA | double | Wait time delta |
| WAITTIME_TOTAL | double | Wait time total, since collection started |
| PHYSICALREAD_DELTA | double | Delta number of physical reads |
| PHYSICALREAD_TOTAL | double | Total number of physical reads, since collection started |
| LOGICALREAD_DELTA | double | Delta number of logical reads |
| LOGICALREAD_TOTAL | double | Total number of logical reads, since collection started |
| PACKETSSENT_DELTA | double | Delta number of network packets sent |
| PACKETSSEND_TOTAL | double | Total number of network packets sent, since collection started |
| PACKETSRECEIVED_DELTA | double | Delta number of network packets received |
| PACKETSRECEIVED_TOTAL | double | Total number of network packets received, since collection started |
| BYTESSENT | double | Network bytes sent |
| BYTESRECEIVED | double | Network bytes received |
| CPUSECS | double | CPU time, in seconds |
| CPUPCT | double | CPU % Used (1 CPU), in interval |
| BYTESSENT_DELTA | double | Network bytes sent delta |
| BYTESRECEIVED_DELTA | double | Network bytes received delta |
| CPUTIME_DELTA | double | CPU time delta, in milliseconds |
| ELAPSEDTIME_DELTA | double | Elapsed time delta, in seconds |
| ELAPSEDTIMEMS_DELTA | double | Elapsed time delta, in milliseconds |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |