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