Friday, February 13, 2009

Number of tasks queued in SQL Server that can be run

The following query shows the number of tasks queued in SQL Server that can be run:

select avg(runnable_tasks_count)   from sys.dm_os_schedulers   where status = 'VISIBLE ONLINE'

If SQL Server frequently has a non-zero number of runnable tasks, then adding additional processors will likely result in more throughput.


No comments:

Post a Comment

 
span.fullpost {display:inline;}