Tips to using this grid
- Click a session in the grid for more details on the session.
- Many applications create multiple connections to SQL Server.
- When there are more than 2000 sessions only those sessions that are active (and those sessions that are blocked and blocking) are shown.
- To show only those sessions that are currently executing, click Show active sessions only.
- To close a SQL Server session, right click and select Kill this session. This option is available only to members of the Spotlight Diagnostic Administrators group.
- The screen refreshes automatically. To pause Auto Refresh click . Click again to re-start auto refresh.
- The status column of the grid is color coded for readability.
- You can view more details for a session by clicking it in this grid. Additional pages are then displayed in the lower half of the drilldown.
General tips to using Spotlight grids
- Some columns may be hidden by default. Right-click the grid headings and select the columns to show.
- To filter the data displayed in this grid to restrict displays to a manageable or relevant set of data, right-click the grid and select View/Edit Filter.
- To find a particular session, right-click and choose Find.
The columns of the grid include:
Number that SQL Server has assigned to uniquely identify the selected session.
SQL Server login name for this session.
Status of the session (runnable, sleeping, blocked etc).
Which SPID (if any) holds locks that this session is waiting on.
Current or previous command executed.
Name of the Database that the session is in.
Display of thread count. Use to display a single row per session as an option.
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.
The CPU time (in milliseconds) the session used per second. Use this column to observe sessions with high recent CPU usage.
I/O per sec
The number of I/O requests serviced per second. Use this column to observe sessions with high I/O usage.
Number of logical reads performed for each request.
Number of physical reads performed for each request.
Number of physical writes performed for each request.
Request Granted Memory
Number of pages allocated to the execution of a query on the request.
CPU-time consumed by the session since SQL Server restart. It is updated every time execution finishes. Units: Milliseconds.
The sum of Total Reads and Total Writes.
Total Logical Reads
Number of logical reads performed for the session.
Number of physical reads performed for the session.
Number of physical writes performed for the session.
Current Wait Time (ms)
Amount of time this session has been waiting. It shows 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). It shows no data if the session is not waiting.
Last Batch Time
Time the last batch started execution.
Time Since Last Batch
Elapsed time since the last batch started execution.
Number of open transactions which corresponds to the session’s @@trancount value.
Program the user is running to access SQL Server.
Name of the client computer.
Workstation process id number.
This is the IP address for the client computer’s network card.
Network protocol being used to establish communication between SQL Server and the application.
Time the session was created.
Returns the ID of the current request within the current session.
Identifier for the query plan. Note the plan handle is available only when the session is executing.
The full batch SQL for this session.
The session Query Plan.
Name of the Windows domain that the specified user belongs to.
Name of the Windows account under which the user is logged on.