Spotlight on SQL Server 10.0.3 - Getting Started Guide

Spotlight on SQL Server Home Page

The Spotlight on SQL Server home page helps you locate system bottlenecks quickly. Related server statistics are grouped together on panels that are connected by a series of graphical flows and icons. Spotlight on SQL Server updates these flows in real time so you can see how quickly data is moving through the system. The icons change color as their values move through the range of thresholds.

The display is based on the SQL Server architecture diagram. See "A review of the SQL Server Architecture" (page 1) for more information.

To see the Spotlight Home Page

1. Select a Spotlight on SQL Server connection from the Spotlight browser.

2. Click Monitor | Home.

   

Notes:

• If the Spotlight Diagnostic Server is unable to collect the data required for the home page or drilldowns, Spotlight displays a small icon on the affected component, chart or grid. Click the icon to see more information about the problem.
• For a Microsoft Cluster Server (MSCS) the Spotlight on SQL Server home page shows information for the current node in the cluster. Drilldowns for the monitored Operating System correlate with the physical machine operating as the current node in the cluster.

Related Topics

Spotlight Home Pages (page 1)

Spotlight on SQL Server Drilldowns (page 1)

Configure the Virtualization Overhead Guage (page 1)