Activity | Session Detail

Displays full detail for a selected session or request. The report is divided into several sections.

Session Information

What It Shows

Comments

SPID

The session id

Login Time

The time that the session last logged in

Login Name

The logged in user for the session

Host

The client computer

Program

The name of the connected application, or the library used (such as .Net or JDBC). If a SQL Agent job, the job name is displayed

Process Id

Windows process id

Last request

The date and time of the last request on this session

tempdb allocation

The amount of tempdb space used by the session and request combined

Total CPU

The total CPU time used by the session since it started, excluding that used by the currently active request

Total reads

The total number of reads on the session since it started, excluding that used by the currently active request

Total writes

The total number of writes on the session since it started, excluding that used by the currently active request

Total logical reads

The total number of logical reads on the session since it started, excluding that used by the currently active request

Open Tx

The number of transactions the session has open, including those from the currently active request

Request Information

This section is only displayed if there is an active request on the session.

What It Shows

Comments

Request Id

The request id

Start time

The time the request started. This is highlighted in orange if more than 1 minute ago (excluding SQL Agent jobs and the sp_server_diagnostics process)

Command

The type of command

CPU

The amount of CPU time used by the request

Reads

The number of reads performed by the request

Writes

The number of writes performed by the request

Logical Reads

The number of logical reads performed by the request

Database

The database specified in the connection, or the default database of the login if none specified

Wait type

If the request is waiting, or blank

Status

This will be one of "running", "runnable", "sleeping", "suspended" or "background"

Wait resource

The resource being waited on

Blocking SPID

If the request is blocked, the session id of the blocking session is highlighted in orange

Managed Code

"YES" if waiting for a CLR procedure or function to finish executing

Progress %

Some operations, such as a backup or restore, report a progress percentage. For most operations this always reads 0

Granted query memory

The total workspace memory granted to the request

Is Agent Job

"YES" if the request is being executed by a SQL Agent job

Session/Request Options

These are the current options for the request (if running) or session.

What It Shows

Comments

Arithmetic abort

Concat null yields null

ANSI null default on

ANSI nulls

ANSI defaults

ANSI warnings

ANSI padding

Lock timeout

Transaction isolation level

Deadlock priority

Connection Details

What It Shows

Comments

Net transport

Protocol type

Client address

Client TCP port

Authentication scheme

Network packet size

Packet reads/writes

Executing SQL

For requests, the currently executing SQL is displayed along with the larger body of SQL that contains it.
This may be a piece of Adhoc SQL or the code within a stored procedure. Encrypted procedures are not shown.

For sleeping sessions, it displays the last SQL that ran on the connection, if available.