Low virtual memory

Determining if your SQL Server instance is experiencing memory issues within the SQL Server Virtual Address Space (VAS) can be a challenge. One way around it is to use the sys.dm_os_ring_buffers.

Install metric...

Metrics install automatically if you have SQL Monitor installed.

If you are using Redgate’s SQL Server monitoring tool, SQL Monitor, you can instantly install and run this metric on your servers.

Determining if your SQL Server instance is experiencing memory issues within the SQL Server Virtual Address Space (VAS) can be a challenge. One way around it is to use the sys.dm_os_ring_buffers to capture alerts registered there that show when virtual memory (also known as internal memory) is low. This is especially useful in situations where you’re running SQL Server on a shared environment with some other service or application.

For more information, see Using sys.dm_os_ring_buffers To Diagnose Memory Issues in SQL Server.

You may also be interested in installing a metric that shows when physical/external memory is low. See Low physical/external memory.

Metric definition

Name

Low Virtual Memory

Description

This metric uses the sys.dm_os_ring_buffers to identify low virtual memory on the SQL Server system. It uses the RING_BUFFER_RESOURCE_MONITOR to identify when the latest alert has a Notification value of RESOURCE_MEMVIRTUAL_LOW.

For more information, see Using sys.dm_os_ring_buffers To Diagnose Memory Issues in SQL Server.

The T-SQL query that will collect data

Instances to collect from

Select all

Databases to collect from

Master

Collection frequency

300

Use collected or calculated values

Leave the Use a calculated rate of change between collections check box unchecked

Metric collection

Enabled

Alert definition

Alert name

Low virtual memory

Description

This alert is raised if an alert of type RESOURCE_MEMVIRTUAL_LOW has been sent to the ring buffers within the last five minutes.

Raise an alert when the metric value goes

Above the defined threshholds

Default threshold values

High:0
Medium:Turn off
Low:Turn off

Raise an alert when the threshold is passed for

1 collection

Alert is

Enabled