Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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 noteImportant

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.