SCOM
Deployment
Requirements
Unpack the Spotlight Management Pack for SCOM
Configure the Spotlight Management Pack for SCOM
Workflow for Spotlight alarms
SCOM Console views of Spotlight
Snooze and acknowledge Spotlight alarms
Launch the Spotlight Client from the SCOM Console
Troubleshooting
Additional Resources
SQL Server | Wait Statistics Drilldown
To see the Wait Statistics drilldown
- Select a SQL Server from Monitored connections.
-
Click Monitor | Wait Statistics.
To investigate...
Look at the...
Where waits are occurring and what is being waited for
Wait Statistics drilldown
Shows the total wait time in milliseconds broken down for the for the following wait types:
- Wait (AlwaysOn)
- Wait (Backup)
- Wait (CLR)
- Wait (DBM)
- Wait (DTC)
- Wait (IO)
- Wait (Latch)
- Wait (Lock)
- Wait (Memory)
- Wait (MISC)
- Wait (Network)
- Wait (Preemptive)
- Wait (ServiceBroker)
- Wait (SOS)
Use this chart to look for trends in wait types over time.
Shows detailed wait statistics for the SQL Server instance currently being monitored.
Wait Time Trend chart|
|
TIP: For more information on Spotlight charts and grids see Spotlight charts and Spotlight grids |
