Virtual Machines

The Virtual Machines page provides an overview of all virtual machines hosting SQL Server instances within your monitored estate, along with key usage metrics such as CPU, memory, and storage utilization.

  • Available from version 14.3.0.2906, with some features appearing in subsequent releases. See the Release Notes for full information.
  • Enhanced data can be shown for VMs hosted in the cloud.  See Managing cloud services for information on how to add credentials to read subscription and cost data from your cloud provider. It also details the roles and permissions necessary.

Understanding the Virtual Machines page

The screenshot below shows an example of the data displayed on this page:

Page overview

This page lists every virtual machine detected in your estate, both on-prem and in the cloud, that hosts a monitored instance. For each machine, you can view various performance and capacity metrics averaged over a selected time period.

The Compare with previous period toggle compares the selected time period against an equivalent preceding period, displaying the difference for each virtual machine. For example, "Last 1 Month" compares the most recent 30 days against the previous 30 days. Your preference is saved and will be remembered when you return to this page. You can use the Period, Filters, Columns, and Density controls to customize the view and export data for further analysis. 

Cloud Information

If the cloud service credentials have been provided (see Managing cloud services) Monitor is able to retrieve subscription and cost details from your cloud provider.

Note

Cost sampling for Azure is supported in Monitor 14.15; cost data for VMs in Amazon Web Services is coming soon

  

Table columns

Metric titleMetric description
Virtual machine nameThe name or IP address of the virtual machine hosting one or more monitored SQL Server instances.
Base MonitorThe base monitor responsible for collecting data from this virtual machine.
GroupThe group or category assigned to the machine in your SQL Monitor estate.
Number of vCPUsThe total number of virtual CPUs allocated to the virtual machine.
Avg. vCPU usedThe average CPU utilization across the selected time period, expressed as a percentage.
Allocated memoryThe total memory allocated to the virtual machine.
Avg. memory usedThe average memory usage over the selected time period.
Allocated storageThe total allocated storage capacity for the virtual machine.
Current storage used

The current amount of storage used, expressed both in absolute size and as a percentage of total allocated storage.

Costs

Billed costs to date for the selected period, in billed currency and USD. This follows the FOCUS™ Specification Billed Cost field


  • Historical usage is averaged over the selected period (e.g., Last month).

  • If monitoring of a virtual machine is suspended, it remains in the list, but its values are shown as “–”.

Viewing Detailed Usage Information for Each Virtual Machine

To drill into the resource usage of a specific virtual machine, click on one of the Virtual Machines in the table. A side panel will appear, displaying additional information


Subscription Details and Estimated Cost (for VMs hosted in supported cloud providers, and where Monitor has been provided access to those details. See Managing cloud services for further information)

Usage showing key metrics

Charts

The side panel contains charts for:

  • vCPU usage and capacity

  • Memory usage and capacity
  • Storage usage and capacity

   

Deeper Analysis

Click on any line in the chart to open the Analysis page for the specific virtual machine, where you can explore trends and compare these metrics with other performance indicators.



Didn't find what you were looking for?