How can we help?
Memory pressure
Memory pressure occurs when the time granting memory (grant_time) is greater than the time requesting memory (request_time):
To query the Performance Store database for queries causing memory pressure, use:
select a.* from dbo.v_activity a where 1 = 1 and a.sample_id = '[sample_id]' and a.server_name = '[server_name]' and a.database_name = '[database_name]' and a.memory_pressure = 1
A quick overview of the number of queries causing memory pressure can be seen on theĀ Overview 1 dashboard:
The alert will be visible on theĀ Latest stats dashboard.
To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.