Provides resource usage and activity information about the objects in use by the referenced command.
Rowset Columns
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.
.gif) Important: |
|---|
|
the DISCOVER_COMMAND_OBJECTS schema rowset does not report activity from $System objects.
|
Restriction Columns
The DISCOVER_COMMAND_OBJECTS rowset can be restricted on the columns listed in the following table.
|
Column name
|
Type indicator
|
Restriction State
|
|---|
|
SESSION_SPID
|
DBTYPE_I4
|
Optional.
|
|
SESSION_ID
|
DBTYPE_WSTR
|
Optional.
|
|
OBJECT_PARENT_PATH
|
DBTYPE_WSTR
|
Optional.
|
|
OBJECT_ID
|
DBTYPE_WSTR
|
Optional.
|
See Also