The Virtualization panel tracks the performance of your virtual machine or host, depending on the selection in the panel. Unexpected spikes in virtual memory or disk usage may warn you about the beginning of a serious performance issue indicating the need for server maintenance to better handle the ongoing workload. 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.
Note that you can customize your Dashboard view to include two Virtualization panels and add one for your virtual machine and the other for your host.
Virtual Memory Usage chart
The Virtual Memory Usage chart displays the amount of memory allocated and used by SQL Server to the total memory consumed on this VM or host server. The Resources > Memory view allows you to track your usage over a period of time, along with other key memory 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 |
|---|---|
Active | Indicates the amount of active memory used by this virtual SQL Server instance. |
Ballooned | Indicates the amount of ballooned memory on this virtual SQL Server instance. A spike in this value alerts you of the low memory status of the host. |
Consumed | Indicates the amount of memory consumed by this virtual SQL Server instance. |
Granted | Indicates the amount of memory granted to this virtual SQL Server instance. |
Swapped | Indicates the amount of swapped memory on this virtual SQL Server instance. A spike in this value alerts you of the low memory status of the host. |
CPU Ready Wait Time gauge
The CPU Ready Wait Time gauge displays the current gauge value of the vCPU Ready Time metric available on the Server Details view. Use this metric to determine the length of time that virtual CPU in your virtual machine is waiting on a physical CPU on your host to become available. A spike in this value may indicate over committed physical CPUs on the host server.
Virtual Disk Usage chart
The Virtual Disk Usage chart displays the amount of data read from and written to disk for the VM or host server during the sample interval. The Resources > Disk view allows you to track your usage over a period of time, along with other key disk statistics.
| Metric | Why it is important |
|---|---|
Disk Read | A high number of disk reads may indicate that the VM or host server is executing poorly-performing queries. |
Disk Write | A high number of disk writes may indicate that the VM or host server is running low on allocated memory. |
Available alerts
- Host Memory Swap Detected Alert
- VM CPU Ready Wait Time (ms) Alert
- VM Memory Swap Detected Alert
- VM Reclaimed/Ballooned Memory (KB) Alert