Out of memory errors

| 0 comments | 8,837 views
Categories: , ,

VN:F [1.9.17_1161]
Rating: 5.0/5 (2 votes cast)

The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there. This won’t provide you with information about specifically what errors might be occurring, but it will help you keep an eye on the system to just be aware of the issue. Use this on a system that is basically configured and operating well as an indicator that you may have an issue. Should you begin to get these on a regular basis you’ll need to add additional memory monitoring.

Out of memory errors, 5.0 out of 5 based on 2 ratings

Metric definition

Metric Name:
Out of memory errors
Description:
This looks for the ring buffer alert type of Out Of Memory, RING_BUFFER_OOM by querying the DMO sys.dm_os_ring_buffers
Enter the T-SQL query that will collect data:
--Ring Buffer OOM errors.
DECLARE @tmp INT;

SELECT  @tmp = 1
FROM    sys.dm_os_ring_buffers AS dorb
        CROSS JOIN sys.dm_os_sys_info AS dosi
WHERE   dorb.ring_buffer_type = 'RING_BUFFER_OOM'
        AND DATEADD(ss,
                    (-1 * ((dosi.cpu_ticks / CONVERT (FLOAT, (dosi.cpu_ticks
                                                              / dosi.ms_ticks)))
                           - dorb.timestamp) / 1000), GETDATE()) > DATEADD(mi,
                                                              -5, GETDATE());

SELECT ISNULL(@tmp, 0);
Select instances to collect from:
Select all
Choose databases to collect from:
Specify databases and type
master
Set collection frequency:
Collect data every minute
Use collected or calculated values:
Leave the Use a calculated rate of change between collections check box turned off
Metric collection is:
Enabled

Alert definition

Alert name:
Out of memory errors
Description:
This alert fires if an Out Of Memory alert has been registered during the preceding five minutes.
Raise an alert when the metric value goes:
Above the defined thresholds
Default threshold values:
Set the thresholds as follows:
High:0
Medium:Turn off check box
Low:Turn off check box
Note: These thresholds are intended as guideline values. If they seem too high or too low for your environment, replace them with values more suited to your server performance.
Raise an alert when the threshold is passed for:
Enter 1 collection
This alert is:
Enabled
VN:F [1.9.17_1161]
Rating: 5.0/5 (2 votes cast)