Low physical/external memory

Determining if your operating system is causing memory issues within your SQL Server instance can be a challenge. One way around it is to use the sys.dm_os_ring_buffers to show when server memory is low.

Install metric...

Metrics install automatically if you have Redgate Monitor installed.

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

Determining if your operating system is causing memory issues within your SQL Server instance 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 server memory (also known as physical 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 virtual memory is low. See Low virtual memory.

Metric definition

Name

Low physical/external memory

Description

This metric uses the sys.dm_os_ring_buffers to identify low physical/external 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_MEMPHYSICAL_LOW.

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 physical/external memory

Description

This alert is raised if an alert of type RESOURCE_MEMPHYSICAL_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