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: 2614 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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

Bookmark It

< Previous : What is the purpose of sys.dm_io_pending_io_reques ...

Next > : What is the purpose of sys.dm_os_schedulers?

Comments or Responses

More Interview Questions by Niladri.Biswas

What is the purpose of sys.dm_os_schedulers?
What is the purpose of sys.dm_os_hosts?
What is the purpose of sys.dm_os_sys_info?
What is Anonymous functions ?
What is Isolated Storage?
What are the steps will followed when consuming WCF in silver light?
Can you provide a list of Layout Management Panels and when you will u ...
When you create a new project in silver light through Visual Studio, h ...

Latest Interview Questions

Discuss the advantages of using Dependency Injection..
What is the use of HTTP modules ?
How do you change the writing direction to "right to left" i ...
How do you detect the user's language preference on ones computer?
How to raise an Exception ?
What is the main use of a finally block in exception handling ?
Will the finally block gets executed, if an exception occurs ?
Where will the control flow if an exception occurs inside a try block ...
More ...