What is the purpose of sys.dm_os_schedulers?
Interview question and answer by: Niladri.Biswas
| Posted on: 7/26/2012 | Category: SQL Server Interview questions
| Views: 427 | | Points: 40
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.
| Alert Moderator
Found interesting? Add this to: