Write a query that will list all the available schedulers in the SQL Server machine and the number of runnable tasks for each scheduler.

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

SELECT
scheduler_id,current_tasks_count,runnable_tasks_count
FROM sys.dm_os_schedulers

Result

scheduler_id	current_tasks_count	runnable_tasks_count

0 8 0
1 12 0
1048578 1 0
1048576 2 0
1048579 1 0
1048580 1 0
1048581 1 0
1048582 1 0
1048583 1 0


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response