What is the purpose of sys.dm_os_schedulers?

 Posted by Niladri.Biswas on 7/26/2012 | Category: Sql Server Interview questions | Views: 1791 | Points: 40
Answer:

This DMV helps to identify if there is any CPU bottleneck in the SQL Server machine. The number of runnable tasks is generally a nonzero value that
indicates that tasks have to wait for their time slice to run. If the runnable task counts show high values, then there is a symptom of CPU bottleneck.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response