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