Parsed SQL plans for current executing statements
(SPID, KPID)
| Name | Data Type | Description |
|---|---|---|
| InstanceID | long | Instance ID; 0 = non-CE |
| SPID | long | Session process ID |
| KPID | long | Kernel process ID |
| SQLID | string(20) | SQL ID; created by Surveillance |
| PLANID | string(20) | Plan ID; created by Surveillance |
| Step | long | Step # in the plan |
| ParentID | long | ID of parent of this node in the plan; 0 = this node is the root node in the plan |
| ID | long | ID of this node in the plan |
| Depth | long | Depth of this node in the plan hierarchy |
| Operation | string(32) | Name of operation for this node |
| Options | string(48) | Options for the operation for this node |
| Object | string(64) | Target object of this operation |
| Object2 | string(64) | Second target object of this operation |
| IOSizeData | long | I/O size used for data pages for this node, in bytes |
| BRSData | string(4) | Buffer Replacement Strategy used for data pages for this node |
| IOSizeIdxLeaf | long | I/O size used for index leaf pages for this node, in bytes |
| BRSIdxLeaf | string(4) | Buffer Replacement Strategy used for index leaf pages for this node |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 15.0 |