Provides resource usage and activity information about the currently executing or last executed commands in the opened connections on the server.
The DISCOVER_COMMANDS rowset contains the following columns.
The CPU time, in milliseconds, consumed by the command since the start of the command execution.
The elapsed time, in milliseconds, since the start of the command.
The ccumulated value of data read from disk, in kilobytes, since the start of the command.
The accumulated number of disk reads since the start of the command.
The date and time the last command started, expressed as UTC time on the server.
The accumulated value of data written to disk, in kilobytes, since the start of the command.
The accumulated number of disk writes since the start of the command.
The number of commands executed since the start of the session.
The session ID.
This schema rowset is not sorted.