Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

SQL Server | Home Page | Sessions Panel

The Sessions panel shows the following information:

Component Description

Response (ms)

Shows the full round-trip response time (in milliseconds) of a query representative of general workload (select 1, by default).

The query used to determine response time is configurable by members of the Spotlight diagnostic administrators group. For more information, see Spotlight diagnostic user groups. Right click the SQL Server (Monitored connections) and select Properties. On the Monitoring page, click SQL Server Response Time. For more information, see Configure | SQL Server Response Time.

Sessions

Shows the number of SQL Server user (non-system) sessions, excluding SQL Server Agent sessions.

Computers

Shows the number of client computers that currently have at least one SQL Server session.

Active

Shows the number of non-system sessions that are actively processing in SQL Server, or are waiting on locks (blocked).

Active Sessions

Shows the percentage of non-system SQL Server sessions that are active (executing), or waiting on locks (blocked).

 

Data Flows

Component Description

Packets/s (sent)

This flow from the Processes panel to the Sessions panel represents the rate at which network packets are being sent from SQL Server to client applications.

Packets/s (received)

This flow from the Sessions panel to the Processes panel represents the rate at which network packets are being received by SQL Server from client applications.

Batches/s

This flow from the Sessions panel to the Processes panel shows the rate at which Batches of SQL statements are being submitted to SQL Server for execution.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating