Performance monitoring command in SQL Server

 
DBCC SQLPERF(umsstats) - This command will provide all the OS related information for your threads in the SQL Server instance. It provides the below values,
 
Node Id
Avg Sched
 LoadSched
SwitchesSched Pass
IO Comp Passes
Scheduler ID (The below data will be populated for each scheduler ID)
    online  - Whether it's online or not
    num tasks  - Number of tasks
    num runnable  - Runnable tasks
    num workers   - Parallel workers involved in the scheduler
    active workers - Active parallel workers involved in the scheduler
    work queued  - Works queued up in this schedule
    cntxt switches - How many context switching happening in this schedule
    cntxt switches(idle)   - Idle threads after context switches.
    preemptive switches - Prirority switches happened in this schedule.
 
 
Cheers,
Ebook Download
View all
Learn
View all