How do you use cloud databases? Take the survey.
Options
Find instances of specific wait type?
PeterDanielsCRB
Posts: 126 Bronze 3
I am seeing THREADPOOL waits as the top wait on an instance since startup. I would like to find out when these are occurring and what is causing them.
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
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
Tagged:
Best Answers
-
OptionsSujay
Posts: 47 Bronze 2
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 -
OptionsPeterDanielsCRB
Posts: 126 Bronze 3
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".
Answers
That's great to know. Glad I was able to help.
Regards,
Sujay