Processes
(SPID, KPID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| LCNAME | string(32) | Logical cluster name, if Cluster Edition |
| SPID | long | Session process ID |
| KPID | long | Kernel process ID |
| FAMILYID | long | Session process ID (SPID) of the parent process, if this is a worker process (for parallel query) |
| BATCHID | long | Batch ID |
| CONTEXTID | long | Context ID |
| LINENUMBER | long | Line number in the batch |
| SECONDSCONNECTED | long | Duration of time connected, in seconds |
| WAITEVENTID | long | Wait event ID |
| BLOCKINGSPID | long | Blocker session process ID (SPID), if applicable |
| ENGINENUMBER | long | Engine ID |
| PRIORITY | long | Priority |
| LOGIN | string(32) | Login name |
| APPLICATION | string(32) | Application name |
| COMMAND | string(32) | General command type |
| NUMCHILDREN | long | Number of child processes, if executing parallel query |
| SECONDSWAITING | long | Duration of time waiting, in seconds |
| BLOCKINGXLOID | long | Blocker lock ID, if applicable |
| DBNAME | string(32) | Database name |
| ENGINEGROUPNAME | string(32) | Engine group name |
| EXECUTIONCLASS | string(32) | Execution class |
| MASTERTRANSACTIONID | string(256) | Master transaction ID |
| TEMPDBNAME | string(32) | TempDB name |
| TEMPDBUSED | double | Current TempDB space used |
| CPUTIME | long | CPU time, in milliseconds |
| CPUSECS | double | CPU time, in seconds |
| WAITTIME | long | Wait time, in milliseconds |
| WAITSECS | double | Wait time, in seconds |
| PHYSICALREADS | double | Number of physical reads |
| PHYSICALWRITES | double | Number of physical writes |
| LOGICALREADS | double | Number of logical reads |
| PHYSICAL_IO | double | Number of physical I/O operations |
| LOGICAL_IO | double | Number of logical I/O operations |
| PAGESREAD | double | Number of pages read |
| PAGESWRITTEN | double | Number of pages written |
| BYTESREAD | double | Number of bytes read |
| BYTESWRITTEN | double | Number of bytes written |
| PAGE_IO | double | Number of page I/O operations |
| MEMUSAGEB | double | Memory usage, in bytes |
| LOCKSHELD | long | Number of locks held by this process |
| TABLEACCESSES | long | Number of pages read without an index |
| INDEXACCESSES | long | Number of pages read with an index |
| TEMPDBOBJECTS | long | Total number of temp tables created (including dropped ones) |
| ULCBYTESWRITTEN | long | Number of bytes written to the user log cache (ULC) for the process |
| ULCFLUSHES | long | Number of times the user log cache (ULC) was flushed |
| ULCFLUSHFULL | long | Number of times the user log cache (ULC) was flushed because it was full |
| ULCMAXUSAGE | long | Maximum space usage of the user log cache (ULC), in bytes |
| ULCCURRENTUSAGE | long | Current space usage of the user log cache (ULC), in bytes |
| TRANSACTIONS | long | Number of transactions started (including finished ones) |
| COMMITS | long | Number of commits |
| ROLLBACKS | long | Number of rollbacks |
| NETWORKPACKETSIZE | long | Size of each network packet, in bytes |
| PACKETSSENT | long | Number of network packets sent |
| PACKETSRECEIVED | long | Number of network packets received |
| BYTESSENT | long | Network bytes sent |
| BYTESRECEIVED | long | Network bytes received |
| TIME_BLOCKED | long | Duration of time blocked, in seconds |
| HOSTNAME | string(32) | Host name |
| CLIENTOSPID | string(32) | Client OS PID |
| IPADDR | string(68) | Client IP address |
| CMD | string(32) | Command or process being executed; if a conditional statement, such as if, then the value is cond |
| STATUS | string(16) | Process status:
|
| CLIENTNAME | string(32) | Client name |
| CLIENTHOSTNAME | string(32) | Client host name |
| CLIENTAPPLNAME | string(32) | Client application name |
| WAITDESCRIPTION | string(256) | Wait event description |
| BLOCKEDCOUNT | long | Total number of processes currently blocked by this process |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| CPUPCT | double | CPU % Used (1 CPU), in interval |
| CPUPCT_AVG | double | Average CPU % Used (1 CPU), since collection started |
| CPUPCT_MAX | double | Maximum CPU % Used (1 CPU), since collection started |
| CPU_DELTA | double | CPU time delta, in seconds |
| CPU_TOTAL | double | CPU time total, in seconds, since collection started |
| SESSION_CPUPCT | double | % of time connected that is CPU time (1 CPU) |
| WAITPCT | double | Wait % (1 CPU), in interval |
| WAITPCT_AVG | double | Average Wait % (1 CPU), since collection started |
| WAITPCT_MAX | double | Maximum Wait % (1 CPU), since collection started |
| WAIT_DELTA | double | Wait time delta, in seconds |
| WAIT_TOTAL | double | Wait time total, in seconds, since collection started |
| LOGICALREADS_DELTA | double | Delta number of logical reads |
| LOGICALREADS_RATE | double | Number of logical reads per second, in interval |
| PHYSICALWRITES_DELTA | double | Delta number of physical writes |
| PHYSICALWRITES_RATE | double | Number of physical writes per second, in interval |
| PHYSICALREADS_DELTA | double | Delta number of physical reads |
| PHYSICALREADS_RATE | double | Number of physical reads per second, in interval |
| LOGICALIO_DELTA | double | Delta number of logical I/O operations |
| LOGICALIO_RATE | double | Number of logical I/O operations per second, in interval |
| LOGICALIO_RATE_MAX | double | Maximum number of logical I/O operations per second, since collection started |
| LOGICALIO_RATE_AVG | double | Average number of logical I/O operations per second, since collection started |
| LOGICALIO_AVG | double | Average of delta number of logical I/O operations, since collection started |
| LOGICALIO_MAX | double | Maximum of delta number of logical I/O operations, since collection started |
| PAGESREAD_DELTA | double | Delta number of pages read |
| PAGESREAD_RATE | double | Number of pages read per second, in interval |
| PAGESWRITTEN_DELTA | double | Delta number of pages written |
| PAGESWRITTEN_RATE | double | Number of pages written per second, in interval |
| TABLEACCESSES_DELTA | double | Delta number of pages read without an index |
| INDEXACCESSES_DELTA | double | Delta number of pages read with an index |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |