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
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
Found interesting? Add this to: