{"name":"Buffer pressure","description":"Uses the difference between \"Target Server Memory\" and \"Total Server Memory\" from SQL Server Memory Manager Object.","tsql":"SELECT  (     \r\n    SELECT    cntr_value   \r\n    FROM      sys.dm_os_performance_counters    \r\n    WHERE     counter_name = 'Target Server Memory (KB)'\r\n) - (     \r\n    SELECT    cntr_value    \r\n    FROM      sys.dm_os_performance_counters   \r\n    WHERE     counter_name = 'Total Server Memory (KB)'\r\n) [Buffer Pressure];","instances":true,"frequency":60,"databases":{"mode":1},"rateofchange":false,"metricenabled":true,"alertname":"Buffer pressure detected","alertdescription":"Any time the target value is greater than the allocated value, you have a buffer memory allocation issue.","aboveorbelow":"below","collections":1,"alertenabled":true,"_thresholds_high":{"selected":true,"value":0},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"targetentitytype":0}