The Sessions grid provides resource usage and activity information for current sessions on the server.

SPID

The session ID.

Connection ID

The connection identifier for the session.

User Name

The session user name.

Current Database

The name of the database that is being used by the current command execution, or the database that was used by the command that last ran.

Last Command Start Time

The date and time when the last command initiated its execution.

Last Command End Time

The date and time when the last command finished its execution.

Last Command Elapsed Time

The elapsed time, in milliseconds, since the end of the command that last ran.

Last Command

The text of the current command running or the command that last ran.

Last Command CPU Time

The CPU time, in milliseconds, consumed by the last command.

Start Time

The date and time the session started.

Elapsed Time

Elapsed time, in milliseconds, since the start of the session.

Idle Time

The idle time, in milliseconds, since the start of the session.

Used Memory

The current size of memory used by the session in kilobytes.

Status

The activity status of the session. 0 = Idle,1 = Active, 2 = Blocked.

Reads

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

Writes

Reads KB

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

Write KB

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

Command Count

The number of commands that started execution since the beginning of the session.

Session ID

The session unique identifier, as a GUID.