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


SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal