Browse by Tags

All Tags » performance » schema » power shell
  • 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 ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on July 24, 2007