Page History
The CPU panel tracks the performance of the processor used by your monitored SQL Server. Unexpected spikes in CPU usage and call rates may warn you about the beginning of a serious performance issue. Chronically high CPU metrics may indicate the need for server maintenance, query tuning, or index updates to better handle the ongoing workload. For additional information, see how to get your CPU performance details.
| Anchor | ||||
|---|---|---|---|---|
|
...
Metric | Why it is important |
|---|---|
A higher SQL usage can indicate that SQL Server is spending too much time processing queries. | |
Total usage | A high total CPU usage can indicate that this server does not have enough resources to adequately process its current workload. |
A high virtual machine usage can indicate that the processor power allocated to this VM is insufficient for its current workload. | |
Host usage | A high host server usage indicates the processing power on this host is insufficient to handle the workload of the currently active VMs. |
...
The CPU Processor Queue Length gauge displays the current value of the processor queue length metric. Use this metric to determine how much work is waiting on this server. A high processor queue could indicate a blocking session or other performance issues.
...
Metric | Why it is important |
|---|---|
A high throughput rate can indicate a higher risk of network, CPU, and resource issues as the SQL Server performance degrades. | |
A high number of compilations (greater than 100 per second) can indicate a high server workload or that there is more recompilation overhead than necessary. | |
A high re-compilation rate can indicate excessive re-compilation overhead. | |
A high rate of transactions can indicate a higher risk of resource issues, such as blocks or locks, due to the heavier workload. |
...
Remember that SQL Diagnostic Manager uses the additional overhead of the hypervisor to calculate the VM metrics. In this situation, the hypervisor knows the VM is just waiting for a CPU, so it does not charge the VM for CPU processing power while it is waiting. The result is that the guest OS reports that it is using the additional processing power.
Available alerts
- Host CPU Usage (Percent) Alert
- OS Processor Time (Percent) Alert
- OS Processor Queue Length (Count) Alert
- SQL Server CPU Usage (Percent) Alert
- VM CPU Usage (Percent) Alert
| Scroll pdf ignore | |||||||
|---|---|---|---|---|---|---|---|
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
...