System Administration

Database: Current Requests

Use the Database: Current Requests page to view information about each database request per session ID that is executing within the SQL server environment.

To access this chart in System Administration, select Admin > Resources > SQL Server Health > Database: Current Requests in the Navigation pane.

Field

Description

SESSION ID

Displays the unique identifier for the session.

REQUEST ID

Displays a unique identifier for the request.

START TIME

Displays the timestamp when the request arrived. This value cannot be NULL.

STATUS

Displays the status of the request. This can be one of the following:

  • Background
  • Running
  • Runnable
  • Sleeping
  • Suspended

This value cannot be NULL.

COMMAND

Displays the current type of command that is being processed. Common command types include the following:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • BACKUP LOG
  • BACKUP DATABASE
  • DBCC
  • FOR

The text of the request can be retrieved by using sys.dm_exec_sql_text with the corresponding sql_handle for the request. Internal system processes set the command based on the type of task they perform. Tasks can include the following:

  • LOCK MONITOR
  • CHECKPOINTLAZY
  • WRITER

This value cannot be NULL.

WAIT TIME

Displays the duration in milliseconds of the current wait, if the request is currently blocked. This value cannot be NULL.