DISCOVER_COMMAND_OBJECTS

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	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.

The DISCOVER_COMMAND_OBJECTS rowset can be restricted on the columns listed in the following table.