Applies To: SQL Server 2016 Preview
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.
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.