{"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","tsql":"--Ring Buffer OOM errors.\r\nDECLARE @tmp INT;\r\n\r\nSELECT  @tmp = 1\r\nFROM    sys.dm_os_ring_buffers AS dorb\r\n        CROSS JOIN sys.dm_os_sys_info AS dosi\r\nWHERE   dorb.ring_buffer_type = 'RING_BUFFER_OOM'\r\n        AND DATEADD(ss,\r\n                    (-1 * ((dosi.cpu_ticks \/ CONVERT (FLOAT, (dosi.cpu_ticks\r\n                                                              \/ dosi.ms_ticks)))\r\n                           - dorb.timestamp) \/ 1000), GETDATE()) > DATEADD(mi,\r\n                                                              -5, GETDATE());\r\n\r\nSELECT ISNULL(@tmp, 0);","instances":true,"frequency":60,"databases":{"mode":1},"rateofchange":false,"metricenabled":true,"alertname":"Out of memory errors","alertdescription":"This alert  fires if an Out Of Memory alert has been registered during the preceding five minutes.","aboveorbelow":"above","collections":1,"alertenabled":true,"_thresholds_high":{"selected":true,"value":0},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"thresholds_comment":"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.","targetentitytype":0}