Server memory can be reduced

Performance Store calculates the average used server memory based on memory consumption for the last 3 months. If the server is having an average usage of less than 80% of the physical server memory, this alert will be thrown.

To query the Performance Store database for server memory that can be reduced, use:

select t.*
from dbo.v_memory_usage t
inner join dbo.v_servers s on s.server_name = t.server_name
inner join dbo.v_cms c with (nolock) on c.server_name = t.server_name
where t.avg_server_memory_used_last_3_months_pct <= 80
and s.availability_group_info in ('AG_ALLPRIMARY', 'AG_ALLPRIMARY_NOTCLEAN', 'NONE')

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.