APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
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 name||Type indicator||Restriction||Description|
|SESSION_SPID||DBTYPE_I4||Yes||The session ID.|
|SESSION_ID||DBTYPE_WSTR||Yes||The session unique identifier, as a GUID.|
|SESSION_COMMAND_COUNT||DBTYPE_I4||The command sequence number.|
|OBJECT_PARENT_PATH||DBTYPE_WSTR||Yes||The path to the parent of the current object.|
|OBJECT_ID||DBTYPE_WSTR||Yes||The ID of the object as defined when it was created.|
|OBJECT_VERSION||DBTYPE_I4||The metadata version number of the object; this number changes every time the object is altered.|
|OBJECT_DATA_VERSION||DBTYPE_I4||The lineage number of the data in the object. This number increments each time the object is processed.|
|OBJECT_CPU_TIME_MS||DBTYPE_I8||The CPU time, in milliseconds, consumed by the object since the start of the command.|
|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_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.|
|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.|
This schema rowset is not sorted.
The DISCOVER_COMMAND_OBJECTS schema rowset does not report activity through DMV queries.
Using ADOMD.NET to return the rowset
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.