Locks
| Name | Description |
|---|---|
| Login | Login name |
| Database | Database name |
| Object | Name of the locked object |
| SPID | Session process ID |
| Blocking SPID | Blocker session process ID (SPID), if applicable |
| Lock Type | Lock type:
|
| LockID | Lock ID |
| Lock State | Lock state (Granted, Requested) |
| Lock Level | Lock level (ROW, PAGE, TABLE, ADDRESS) |
| Wait Time | Duration of time waiting on the lock |
| Page | Page # that is locked if LockType = PAGE |
| Row | Row # that is locked if LockType = ROW |
| Inst ID | Instance ID; 0 = non-CE |
| KPID | Kernel process ID |
| Name | Description |
|---|---|
| ID | ID of this node in the plan |
| Parent ID | ID of parent of this node in the plan; 0 = this node is the root node in the plan |
| Operation | Name of operation for this node |
| Options | Options for the operation for this node |
| Object | Target object of this operation |
| Object2 | Second target object of this operation |
| IO Size Data Pages | I/O size used for data pages for this node |
| BRS Data Pages | Buffer Replacement Strategy used for data pages for this node |
| IO Size Index Leaf Pages | I/O size used for index leaf pages for this node |
| BRS Index Leaves | Buffer Replacement Strategy used for index leaf pages for this node |
| Name | Description |
|---|---|
| Inst ID | Instance ID; 0 = non-CE |
| SPID | Session process ID |
| Context ID | Current context ID of the procedure |
| Stmt # | Current statement number (unique in a batch) of the procedure |
| Type | Type of procedure (stored procedure, etc.) in the stack |
| Object | Name of the procedure in the stack |
| Line # | Current line number of the procedure |
| Compile Time | Compile date of the procedure |
| Owner | Name of the owner of the procedure |
| Database | Name of the database that contains the procedure |
| Memory | Memory usage |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |