SQL Server Aggregator

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, Read More...
Published Tuesday, July 24, 2007 9:01 PM by SSQA.net
Anonymous comments are disabled