The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any CPU bottleneck in the SQL Server machine. SELECT scheduler_id,current_tasks_count,runnable_tasks_count FROM sys.dm_os_schedulers WHERE scheduler_id < 255 By looking at the results of above query, the number of runnable tasks is generally a nonzero...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/08/17/1549.aspx