Find instances of specific wait type?

PeterDanielsCRB

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

Sujay

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

PeterDanielsCRB

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".

Sujay

Hi Peter,

That's great to know. Glad I was able to help.

Regards,
Sujay