DISCOVER_COMMAND_OBJECTS
Provides resource usage and activity information about the objects in use by the referenced command.
The DISCOVER_COMMAND_OBJECTS rowset contains the following columns.
Column name | Type indicator | Length | Description |
|---|---|---|---|
OBJECT_CPU_TIME_MS | DBTYPE_I8 |
| The CPU time, in milliseconds, consumed by the object since the beginning of the command. |
OBJECT_DATA_VERSION | DBTYPE_I4 |
| The lineage number of the data in the object. This number increments each time the object is processed. |
OBJECT_ID | DBTYPE_WSTR |
| The ID of the object as defined when it was created. |
OBJECT_PARENT_PATH | DBTYPE_WSTR |
| The path to the parent of the current object. |
OBJECT_READ_KB | DBTYPE_I8 |
| The accumulated value of data, in kilobytes, read by the object since the start of the command. |
OBJECT_READS | DBTYPE_I8 |
| The accumulated number of read operations by the object since the start of the command. |
OBJECT_ROWS_RETURNED | DBTYPE_I8 |
| The number of rows returned by the object to the caller since the start of the command. |
OBJECT_ROWS_SCANNED | DBTYPE_I8 |
| The number of rows scanned by the object since the start of the command. |
OBJECT_VERSION | DBTYPE_I4 |
| The metadata version number of the object; this number changes every time the object is altered. |
OBJECT_WRITE_KB | DBTYPE_I8 |
| The accumulated value of data, in kilobytes,written by the object since the start of the command. |
OBJECT_WRITES | DBTYPE_I8 |
| The accumulated number of write operations by the object since the start of the command. |
SESSION_COMMAND_COUNT | DBTYPE_I4 |
| The command sequence number. |
SESSION_ID | DBTYPE_WSTR |
| The session unique identifier, as a GUID. |
SESSION_SPID | DBTYPE_I4 |
| The session ID. |
This schema rowset is not sorted.
 Important |
|---|
the DISCOVER_COMMAND_OBJECTS schema rowset does not report activity from $System objects. |
