Share via

3.1.4.2.2.1.3.54.1 Columns

  • Article

The DISCOVER_COMMANDS rowset contains the following columns.

Name

Type

Restriction

Description

SESSION_SPID

xsd:int

Yes

The session ID.

SESSION_COMMAND_COUNT

xsd:int

The number of commands executed since the start of the session.

COMMAND_START_TIME

xsd:dateTime

The date and time the last command started, expressed as UTC time on the server.

COMMAND_ELAPSED_TIME_MS

xsd:long

The elapsed time, in milliseconds, since the start of the command.

COMMAND_CPU_TIME_MS

xsd:long

The CPU time, in milliseconds, consumed by the command since the start of the command execution.

COMMAND_READS

xsd:long

The accumulated number of disk reads since the start of the command.

COMMAND_READ_KB

xsd:long

The accumulated value of data read from disk, in kilobytes, since the start of the command.

COMMAND_WRITES

xsd:long

The accumulated number of disk writes since the start of the command.

COMMAND_WRITE_KB

xsd:long

The accumulated value of data written to disk, in kilobytes, since the start of the command.

COMMAND_TEXT

xsd:string

The command text.

COMMAND_END_TIME

xsd:dateTime

The server UTC date and time when the command finishes its execution.

The rowset is not sorted.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="SESSION_SPID" name="SESSION_SPID" type="xsd:int" 
                        minOccurs="0" />
           <xsd:element sql:field="SESSION_COMMAND_COUNT" name="SESSION_COMMAND_COUNT" 
                        type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="COMMAND_START_TIME" name="COMMAND_START_TIME" 
                        type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="COMMAND_ELAPSED_TIME_MS" name="COMMAND_ELAPSED_TIME_MS" 
                        type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="COMMAND_CPU_TIME_MS" name="COMMAND_CPU_TIME_MS" 
                        type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="COMMAND_READS" name="COMMAND_READS" type="xsd:long" 
                        minOccurs="0" />
           <xsd:element sql:field="COMMAND_READ_KB" name="COMMAND_READ_KB" type="xsd:long" 
                        minOccurs="0" />
           <xsd:element sql:field="COMMAND_WRITES" name="COMMAND_WRITES" type="xsd:long" 
                        minOccurs="0" />
           <xsd:element sql:field="COMMAND_WRITE_KB" name="COMMAND_WRITE_KB" type="xsd:long" 
                        minOccurs="0" />
           <xsd:element sql:field="COMMAND_TEXT" name="COMMAND_TEXT" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="COMMAND_END_TIME" name="COMMAND_END_TIME" 
                        type="xsd:dateTime" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>