About Spotlight on SQL Server
Installation and Upgrade
Connections to SQL Servers
Use Spotlight on SQL Server
Diagnose CPU
Diagnose IO
Diagnose Blocking
View Historical Data
Identify Expensive SQL
Playback Database
Troubleshooting, Permissions & Maintenance
Turn on and configure SQL Analysis
Real-Time Data and Expensive SQL
Filter Displayed and Collected Data
Analyze Wait Statistics
Find Long Running SQL
Configure the Virtualization Overhead Guage
Spotlight on SQL Server and Firewalls
Permissions
Unable to collect data
Enabling Performance Data
WMI Issues
Spotlight on SQL Server and Windows domains
Session Trace Errors
Unable to establish a Spotlight connection to a SQL Server instance
Connection Issues
Monitor Multiple SQL Server Instances
Spotlight Diagnostic User Groups
Maintenance
Drilldowns Ribbon Group
A drilldown is a display of the performance statistics for a connected system.
To see the drilldowns ribbon group
- Select a connection from the Spotlight browser.
- Select the Monitor ribbon tab.
-
Click to show:
Drilldowns Description A unique view of the activity of the connected system. The Spotlight Home Page highlights obvious bottlenecks and problem areas. Statistics and flows are updated in real time.
Other drilldowns
For information on the drilldowns available refer to the type of connection.
The drilldowns make use of two types of displays: grids (or tables) and charts.
