SOS_WORK_DISPATCHER Wait

Added in SQL Server 2019 and Azure SQL Databases to track when a thread becomes idle and stops when the thread is given something to do. This wait type is not an indication of a problem other than the server does not have enough work to do.

Usually should be filtered out as something to ignore. I usually include this in my wait types to ignore list when looking for problems.

If this is your only significant wait as shown in the chart above that that is an indication that you may have more CPU than you need on your server, and when combining it with a chart showing CPU usage, I would expect that there is very little CPU load on the server.

Enroll Today!

---

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!