SQL Server Management Studio Standard Reports – Tasks

SQL Server Management Studio Standard Reports – Tasks

Rate This
  • Comments 3

I'm continuing my series on the Standard Reports in SQL Server Management Studio, and today we’re in the Management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that appears, click the Standard Reports, and then select the title at the top of this post.

This report shows information about the tasks that are running on your system, and some useful blocking information.

The first section of the report is a graph showing a comparison of the running versus suspended tasks.

The second section of this report shows tasks according to their state:

Column Description
State Whether the task is running or suspended
Session ID A unique number assigned to this session
Request ID A unique number assigned to this request within a session
Scheduler ID A unique number assigned to this request ID task for a scheduler task
Login Name The login name associated with this request ID
CPU Time (ms.) The amount of CPU time taken by this request-ID
Memory Used (bytes) The amount of memory used by this request ID
# Pending IO The number of I/O operations that are pending on this request
# Context Switches The amount of context switching in this request ID. There’s a lot more on context switching here
Task Address The memory location of the request ID
Sql Statement A partial rendering of the T-SQL statement in this request ID

The next band of the report shows information about blocking by tasks:

Column Description
Task Address The memory location of the task
Session ID A unique number assigned to this task
Request ID A unique number assigned within this task within a session
Blocking Task Session ID** The session ID associated with the session doing the blocking - this only shows up if there is blocking
Blocking Task Request ID The request ID associated with the session doing the blocking
Scheduler ID A unique number assigned to this task for a scheduler task
Login Name The login name associated with this task
Blocking Task Login Name The login name on the blocking task
Wait Time (ms.) The amount of time spent in the blocking
Wait Type The type of wait operation in the block. More on those here 
CPU Time (ms.) The amount of CPUtime spent in this task
Memory Used (bytes) The amount of memory used by this task
Blocking Task Address The memory address of the blocking task
Blocked SQL Statement A portion of the T-SQL statement that is being blocked
Blocking SQL Statement A portion of the SQL statement that is blocking this task
Leave a Comment
  • Please add 7 and 1 and type the answer here:
  • Post
Page 1 of 1 (3 items)