How to monitor Worker Threads in Performance Advisor
Normally worker threads are not something we need to monitor, but recently we ran into some issues, where the worker count was higher than the max worker count. Thanks to SQL Sentry we were able to find the issue, but so far it is not solved. Therefore we would like to see them on the dashboard with the historical data and how it changed over time..
We added a Custom Condition to query sys.dm_os_schedulers to monitor the "current_workers_count" and display it in the "Activity" and in the "Waits" chart. But this only alerts us, when the value is exceeded, but does not show, how it progresses..
Is it somehow possible to add the worker count to the dashboard?
Thank you for your help.
In order to assist you in an efficient manner, can you please submit a support ticket to firstname.lastname@example.org? Please make sure to reference this post when submitting the ticket.