CPU Bound?

This query will show queued tasks in SQL 2005. Normally the last column should be all zero’s.

select
scheduler_id,
current_tasks_count,
runnable_tasks_count
from
sys.dm_os_schedulers
where
scheduler_id < 255