DISCOVER_COMMANDS
Provides resource usage and activity information about the currently executing or last executed commands in the opened connections on the server.
Rowset Columns
The DISCOVER_COMMANDS rowset contains the following columns.
Column name |
Type indicator |
Length |
Description |
---|---|---|---|
COMMAND_CPU_TIME_MS |
DBTYPE_I8 |
|
The CPU time, in milliseconds, consumed by the command since the start of the command execution. |
COMMAND_ELAPSED_TIME_MS |
DBTYPE_I8 |
|
The elapsed time, in milliseconds, 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_READS |
DBTYPE_I8 |
|
The accumulated number of disk reads since the start of the command. |
COMMAND_START_TIME |
DBTYPE_DBTIMESTAMP |
|
The date and time the last command started, expressed as UTC time on the server. |
COMMAND_WRITE_KB |
DBTYPE_I8 |
|
The accumulated value of data written to 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. |
SESSION_COMMAND_COUNT |
DBTYPE_I4 |
|
The number of commands executed since the start of the session. |
SESSION_SPID |
DBTYPE_I4 |
|
The session ID. |
This schema rowset is not sorted.
Restriction Columns
The DISCOVER_COMMANDS rowset can be restricted on the columns listed in the following table.
Column name |
Type indicator |
Restriction State |
---|---|---|
SESSION_SPID |
DBTYPE_I4 |
Optional. |