TechNet
Export (0) Print
Expand All

DISCOVER_COMMANDS Rowset

 

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 nameType indicatorRestrictionDescription
SESSION_SPIDDBTYPE_I4YesThe session ID.
SESSION_COMMAND_COUNTDBTYPE_I4The number of commands executed since the start of the session.
COMMAND_START_TIMEDBTYPE_DBTIMESTAMPThe date and time the last command started, expressed as UTC time on the server.
COMMAND_ELAPSED_TIME_MSDBTYPE_I8The elapsed time, in milliseconds, since the start of the command.
COMMAND_CPU_TIME_MSDBTYPE_I8The CPU time, in milliseconds, consumed by the command since the start of the command execution.
COMMAND_READSDBTYPE_I8The accumulated number of disk reads since the start of the command.
COMMAND_READ_KBDBTYPE_I8The ccumulated value of data read from disk, in kilobytes, since the start of the command.
COMMAND_WRITESDBTYPE_I8The accumulated number of disk writes since the start of the command.
COMMAND_WRITE_KBDBTYPE_I8The accumulated value of data written to disk, in kilobytes, since the start of the command.
COMMAND_TEXTDBTYPE_WSTRThe command text.
COMMAND_END_TIMEDBTYPE_DBTIMESTAMPThe 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.

ArgumentValue
GUIDa07ccd34-8148-11d0-87bb-00c04fc33942
ADOMDNAMECommands

XML for Analysis Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft