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

Incorrect memory configuration

Incorrect memory configuration is when the sum of maximum allocated SQL Server memory for each instance on the same machine is exceeding the total available memory on the machine.

To query the Performance Store database for servers with an incorrect memory configuration, use:

select s.computer_name server_name, s.physical_memory_mb, sum(convert(bigint, s.max_mem_mb)) max_mem_mb
from dbo.v_servers s
group by s.computer_name, s.physical_memory_mb
having sum(convert(bigint, s.max_mem_mb)) >= s.physical_memory_mb

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