Page History
...
The CPU Usage chart displays the percentage of processing power in use on the computer that hosts the SQL Server instance over a period of time. The CPU view on the Resources view allows you to track your CPU usage over a period of time, along with other key CPU statistics. For additional information about how SQL Diagnostic Manager works with virtual machines and collects metrics, see How SQL Diagnostic Manager works with a virtual environment.
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. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The CPU Call Rates chart breaks down the processor workload into the number of batches, compilations, and transactions completed each second, giving you a detailed view of which activities are resource-intensive.
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. |
Differences in statistics
...
- 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 |
|---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |
...