SQL Database CPU Dashboard


SQL Server scheduler usage information is displayed in the 3 left hand graphs.

Active Workers - number of workers per scheduler that have an associated task, and are either running, runnable, or suspended

Runnable Tasks - number of workers per scheduler with tasks assigned to them, that are waiting to be scheduled on the runnable queue

Pending IO - Number of pending I/Os per scheduler that are waiting to be completed


SQL Server cached queries

The core usage as well as total CPU usage and CPU history are displayed in the 3 right hand graphs.

Not Connecting To Performance Monitor

MiniDBA is dependent on conncting to the SQL Server's built in performance monitor counters. If the it says it is unable to connect then this screen will not have sample data available.
To troubleshoot perfmon connectivity visit this link