Welcome to

SqlServer-QA.net

Sign in | Join | Help

List the wait resources and scheduler waits from OS

Got the below script from PSS when we were dealing with a support case to identify the root cause for Scheduler errors during a performance loss & exception errors exercise:

select
scheduler_id,
current_tasks_count,
runnable_tasks_count,
current_workers_count,
active_workers_count,
work_queue_count,
load_factor
from sys.dm_os_schedulers
where scheduler_id < 255

In this regard highlight on SchedulerRelatedDMVs blog from Linchi shea. Also another reason to take advantage of SQLOS and make use of PowerShell script from operating system.

Published Tuesday, July 24, 2007 4:01 AM by SQL Master

Comments

# List the wait resources and scheduler waits from OS

Got the below script from PSS when we were dealing with a support case to identify the root cause for

Tuesday, July 24, 2007 4:32 AM by SSQA.net - SqlServer-QA.net
Anonymous comments are disabled