Provides resource usage and activity information about the currently executing or last executed commands in the opened connections on the server.
Applies to: tabular models, multidimensional models
The DISCOVER_COMMANDS rowset contains the following columns.
|Column name||Type indicator||Restriction||Description|
|SESSION_SPID||DBTYPE_I4||Yes||The session ID.|
|SESSION_COMMAND_COUNT||DBTYPE_I4||The number of commands executed since the start of the session.|
|COMMAND_START_TIME||DBTYPE_DBTIMESTAMP||The date and time the last command started, expressed as UTC time on the server.|
|COMMAND_ELAPSED_TIME_MS||DBTYPE_I8||The elapsed time, in milliseconds, since the start of the command.|
|COMMAND_CPU_TIME_MS||DBTYPE_I8||The CPU time, in milliseconds, consumed by the command since the start of the command execution.|
|COMMAND_READS||DBTYPE_I8||The accumulated number of disk reads since the start of the command.|
|COMMAND_READ_KB||DBTYPE_I8||The ccumulated value of data read from disk, in kilobytes, since the start of the command.|
|COMMAND_WRITES||DBTYPE_I8||The accumulated number of disk writes since the start of the command.|
|COMMAND_WRITE_KB||DBTYPE_I8||The accumulated value of data written to disk, in kilobytes, since the start of the command.|
|COMMAND_TEXT||DBTYPE_WSTR||The command text.|
|COMMAND_END_TIME||DBTYPE_DBTIMESTAMP||The server UTC date and time when the command finishes its execution.|
This schema rowset is not sorted.
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.