Comments
3 comments
-
Hi Peter,
The following link provides more information on the wait statistics https://documentation.red-gate.com/sm/sql-server-performance-and-activity-monitoring/dashboards-and-overviews/server-overview-pages/performance-diagnostics-queries-and-waits
To find the details of a specific wait that is occurring, please refer to the following link https://documentation.red-gate.com/sm/sql-server-performance-and-activity-monitoring/dashboards-and-overviews/server-overview-pages/performance-diagnostics-queries-and-waits/top-10-waits
The section "Viewing wait documentation" should be of help.
Regards,
Sujay -
Thank you, Sujay. That's helpful. I was able to select the Top 10 Waits, then choose "all of history", then select a wait type. For some, it showed some related queries. For others it did not. I'm trying to correlate with SQL Agent jobs, so what would be really cool would be if I could see this info in the analysis page. That way I would be able to see patterns of wait "bubbles".
-
Hi Peter,
That's great to know. Glad I was able to help.
Regards,
Sujay
Add comment
Please sign in to leave a comment.
Unsure how best to go about this. Started going down the path of query the monitoring DB, found some interesting tables, but struggling to work with them.
Any ideas to help would be greatly appreciated.
Cheers,
-Peter