Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...