To see the Wait Statistics drilldown
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.
|
TIP: For more information on Spotlight charts and grids see Spotlight charts and Spotlight grids |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy