Browse by Tags

All Tags » dmv » sqlos » power shell (RSS)
List the wait resources and scheduler waits from OS
Published 24 July 7 6:1 AM | SSQA.net
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...
Filed under: , , , , ,