.png)
DISCOVER_SESSIONS
Provides resource usage and activity information about the currently opened sessions on the server.
The DISCOVER_SESSIONS rowset contains the following columns.
Column name | Type indicator | Length | Description |
|---|---|---|---|
SESSION_COMMAND_COUNT | DBTYPE_I4 |
| The number of commands that started execution since the beginning of the session. |
SESSION_CONNECTION_ID | DBTYPE_I4 |
| The connection identifier for the session. |
SESSION_CPU_TIME_MS | DBTYPE_UI8 |
| The CPU time, in milliseconds, consumed by all requests since the beginning of the session. |
SESSION_CURRENT_DATABASE | DBTYPE_WSTR |
| The name of the database that is being used by the current command execution, or the database that was used by the last command executed. |
SESSION_ELAPSED_TIME_MS | DBTYPE_UI8 |
| Elapsed time, in milliseconds, since the start of the session. |
SESSION_ID | DBTYPE_WSTR |
| The session unique identifier, as a GUID. |
SESSION_IDLE_TIME_MS | DBTYPE_UI8 |
| The idle time, in milliseconds, since the start of the session. |
SESSION_LAST_COMMAND | DBTYPE_WSTR |
| The text of the current command executing or the last command executed. |
SESSION_LAST_COMMAND_CPU_TIME_MS | DBTYPE_UI8 |
| The CPU time, in milliseconds, consumed by SESSION_LAST_COMMAND. |
SESSION_LAST_COMMAND_ELAPSED_TIME_MS | DBTYPE_UI8 |
| The elapsed time, in milliseconds, since the start of SESSION_LAST_COMMAND. |
SESSION_LAST_COMMAND_END_TIME | DBTYPE_DBTIMESTAMP |
| The UTC server time at the moment the last command finished executing. |
SESSION_LAST_COMMAND_START_TIME | DBTYPE_DBTIMESTAMP |
| The UTC server time at the moment the last command started executing. |
SESSION_PROPERTIES | DBTYPE_WSTR |
| Reserved for future use. |
SESSION_READ_KB | DBTYPE_UI8 |
| The accumulated value of data read from disk, in kilobytes, since the start of the session. |
SESSION_READS | DBTYPE_UI8 |
| The accumulated number of disk reads since the start of the session. |
SESSION_SPID | DBTYPE_I4 |
| The session ID. |
SESSION_START_TIME | DBTYPE_DBTIMESTAMP |
| The date and time the session started as UTC time to the server. |
SESSION_STATUS | DBTYPE_I4 |
| The activity status of the session. 0 means "Idle": No current activity is ongoing. 1 means "Active": The session is executing some requested task. 2 means is "Blocked": The session is waiting for some resource to continue executing the suspended task. |
SESSION_USED_MEMORY | DBTYPE_I4 |
| The current size of memory used by the session in kilobytes. |
SESSION_USER_NAME | DBTYPE_WSTR |
| The session user name. |
SESSION_WRITE_KB | DBTYPE_UI8 |
| The accumulated value of data written to disk, in kilobytes, since the start of the session. |
SESSION_WRITES | DBTYPE_UI8 |
| The accumulated number of disk writes since the start of the session. |
This schema rowset is not sorted.
The DISCOVER_SESSIONS rowset can be restricted on the columns listed in the following table.
Column name | Type indicator | Restriction State |
|---|---|---|
SESSION_ID | DBTYPE_WSTR | Optional. |
SESSION_SPID | DBTYPE_I4 | Optional. |
SESSION_CONNECTION_ID | DBTYPE_I4 | Optional. |
SESSION_USER_NAME | DBTYPE_WSTR | Optional. |
SESSION_CURRENT_DATABASE | DBTYPE_WSTR | Optional. |
SESSION_ELAPSED_TIME_MS | DBTYPE_UI8 | Optional. |
SESSION_CPU_TIME_MS | DBTYPE_UI8 | Optional. |
SESSION_IDLE_TIME_MS | DBTYPE_UI8 | Optional. |
SESSION_STATUS | DBTYPE_I4 | Optional. |
