Threshold events for configured resource limitations
(INSTANCEID, KPID, BATCHID, LINENUMBER)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| SPID | long | Session process ID |
| KPID | long | Kernel process ID |
| KTID | long | Kernel thread ID |
| SERVERUSERID | long | Server user ID |
| FAMILYID | long | Session process ID (SPID) of the parent process, if the row is a worker process (for parallel query) |
| DBID | long | Database ID |
| PROCEDUREID | long | Procedure ID; 0 = not a procedure |
| BATCHID | long | Batch ID |
| LINENUMBER | long | Line number of the statement |
| TEMPDBOBJECTS | long | Total number of temporary tables created by the process |
| RANGEID | long | Range ID of the resource limit |
| LIMITID | long | Resource limit ID |
| LIMITVALUE | long | Value of the violated limit |
| ENFORCED | long | Whether limit is enforced before or during query |
| REPORTDATETIME | time | Time when limit violation was reported |
| LOGIN | string(32) | Login name |
| APPLICATION | string(32) | Application name |
| HOSTNAME | string(32) | Host name |
| CLIENTNAME | string(32) | Client name |
| CLIENTHOSTNAME | string(32) | Client host name |
| CLIENTAPPLNAME | string(32) | Client application name |
| CLIENTIP | string(68) | Client IP address |
| COMMAND | string(32) | General command type |
| DBNAME | string(32) | Database name |
| BLOCKINGSPID | long | SPID of the process holding the lock, if a lock was being requested |
| LIMITTYPE | string(32) | Type of resource limit |
| ACTION | string(32) | Action to perform when resource limit is violated |
| SCOPE | string(32) | Scope of the resource limit |
| SQLTEXT | string(256) | SQL text of the threshold event |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 16.0 |