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.