TechNet
Export (0) Print
Expand All

DISCOVER_COMMAND_OBJECTS Rowset

 

Applies To: SQL Server 2016 Preview

Provides resource usage and activity information about the objects in use by the referenced command.

Applies to: tabular models, multidimensional models

The DISCOVER_COMMAND_OBJECTS rowset contains the following columns.

Column nameType indicatorRestrictionDescription
SESSION_SPIDDBTYPE_I4YesThe session ID.
SESSION_IDDBTYPE_WSTRYesThe session unique identifier, as a GUID.
SESSION_COMMAND_COUNTDBTYPE_I4The command sequence number.
OBJECT_PARENT_PATHDBTYPE_WSTRYesThe path to the parent of the current object.
OBJECT_IDDBTYPE_WSTRYesThe ID of the object as defined when it was created.
OBJECT_VERSIONDBTYPE_I4The metadata version number of the object; this number changes every time the object is altered.
OBJECT_DATA_VERSIONDBTYPE_I4The lineage number of the data in the object. This number increments each time the object is processed.
OBJECT_CPU_TIME_MSDBTYPE_I8The CPU time, in milliseconds, consumed by the object since the start of the command.
OBJECT_READ_KBDBTYPE_I8The accumulated value of data, in kilobytes, read by the object since the start of the command.
OBJECT_READSDBTYPE_I8The accumulated number of read operations by the object since the start of the command.
OBJECT_WRITE_KBDBTYPE_I8The accumulated value of data, in kilobytes,written by the object since the start of the command.
OBJECT_WRITESDBTYPE_I8The accumulated number of write operations by the object since the start of the command.
OBJECT_ROWS_RETURNEDDBTYPE_I8The number of rows returned by the object to the caller since the start of the command.
OBJECT_ROWS_SCANNEDDBTYPE_I8The number of rows scanned by the object since the start of the command.

This schema rowset is not sorted.

System_CAPS_ICON_important.jpg Important


The DISCOVER_COMMAND_OBJECTS schema rowset does not report activity through DMV queries.

When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.

The following table provides the GUID and string values that identify this rowset.

ArgumentValue
GUIDa07ccd35-8148-11d0-87bb-00c04fc33942
ADOMDNAMECommandObjects

XML for Analysis Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft