SQL Server Performance

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 17, 2007.

  1. Anonymous New Member

    The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks &amp; active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any CPU bottleneck in the SQL Server machine. SELECT scheduler_id,current_tasks_count,runnable_tasks_count FROM sys.dm_os_schedulers WHERE scheduler_id &lt; 255 By looking at the results of above query, the number of runnable tasks is generally a nonzero...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/08/17/1549.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1549" width="1" height="1">

Share This Page