Page History
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.
| Tip |
|---|
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. |
...
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. |
| Anchor | ||||
|---|---|---|---|---|
|
...
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
| Scroll pdf ignore | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
| ||||||||||||||||||||||||||||||||||||||||||||||||||
| Newtabfooter | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal