Skip to main content
How can we help?
< All Topics
Print

Instance memory can be reduced

Performance Store calculates the average used instance memory based on memory consumption for the last 3 months. If the instance has more than 4 GB ram assigned, and is having an average usage of less than 80% of the assigned max memory, this alert will be thrown.

To query the Performance Store database for instance 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
where t.avg_instance_memory_used_last_3_months_pct <= 80
and s.availability_group_info in ('AG_ALLPRIMARY', 'AG_ALLPRIMARY_NOTCLEAN', 'NONE')
and t.max_mem > 4096

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.

Table of Contents