Note: This feature is available only in Spotlight on SQL Server Enterprise.
Use the Diagnostics drilldown when conducting exploratory exercises into high CPU usage or I/O consumption on your monitored server, and to answer questions such as:
You can also diagnose CPU and I/O pressure from current and historical alarms.
To see the Diagnostics drilldown
Click Monitor | Diagnostics.
To investigate...
Look at the...
CPU pressure CPU page
Note: Data relating to Excessive Query Optimization and Query Execution is not available for SQL Server 2000. Top 25 Adhoc SQL Statements is additionally not available for SQL Server 2005.
Shows possible causes of CPU pressure and the likelihood that each is contributing to high CPU usage on the server being monitored. Click an item in the grid to display an explanation of the diagnosis and supporting information.
Shows processor details and current CPU usage.
I/O pressure I/O
Note: Data relating to Query Execution, Excessive Page_IO_Latch waits and Log waits is not available for SQL Server 2000.
Shows possible causes of I/O pressure and the likelihood that each is contributing to the currently observed I/O consumption. Click an item in the grid to display an explanation of the diagnosis and supporting information.
Shows details of current I/O consumption.
To diagnose CPU or I/O pressure from an alarm
Click Monitor | Alarm Log.
Select one of the following alarms:
Click Diagnose.
Diagnose CPU Pressure grid