SQL SERVER DBA, Linux and Azure: How many tasks are currently waiting?

How many tasks are currently waiting?

select
count(*)
from
sys.dm_os_waiting_tasks

This query will give you an idea of how many tasks are waiting in the system. You can use this information to understand blocking characteristics of your load

No comments:

Post a Comment