Tips for use
- Click a session in the grid to view more details.
- To find a particular session, right-click and choose Find.
- Some of these columns may be hidden by default. To view them, right-click the grid headings and select which columns you want to view.
Columns in this grid include:
SPID
Number that the SQL Azure database has assigned to uniquely identify the selected session.
SQL User
The SQL Azure database login name for this session.
Status
Status of the session (running, sleeping, blocked etc).
Blocked By
Which SPID (if any) holds locks that this session is waiting on.
Last Command
Current or previous command that ran.
Memory
Number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process.
CPU
Total CPU that this session has used since the last refresh.
I/O
Total I/O that this session has used since the last refresh.
Logical Reads
Number of logical reads performed for each request.
Reads
Number of physical reads performed for each request.
Writes
Number of physical writes performed for each request.
Total CPU
Total time that this session has used since connecting to the SQL Azure database.
Total I/O
Total number of I/O operations performed for the session.
Total Logical Reads
Number of logical reads performed for the session.
Total Reads
Number of physical reads performed for the session.
Total Writes
Number of physical writes performed for the session.
Current Wait Time (ms)
Amount of time this session has been waiting. This will show 0 if the session is not currently waiting.
Last Wait Type
Describes the type of wait that this session last waited on (or is currently waiting on).
Last Wait Resource
Describes the resource that this session last waited for (or is currently waiting for). Blank if the session is not currently waiting
Last Batch Time
Time the last batch started execution.
Time Since Last Batch
Elapsed time since the last batch started execution.
Tran Count
Number of open transactions which corresponds to the session’s @@trancount value.
Program
Program the user is running to access the SQL Azure database.
Host Name
Name of the client computer.
Host Process
Workstation process id number.
Net Library
Network protocol being used to establish communication between SQL Server and the application.
Login Time
Time the session was created.
Request ID
Returns the ID of the current request within the current session.
Plan Handle
Identifier for the query plan. Note the plan handle is available only when the session is running.
SQL Handle
Internal handle to the SQL for this plan (This column is hidden by default).