Alerts
Alert 2025
Max Memory
Alert 2025 is a SQL instance alert and is triggered when dbOmnibus detects an issue with the MAX Memory configuration value.
It is recommended that the Server Max Memory configuration be investigated and configured per recommended best practices.
Note: The Max Memory metric is not evaluated for Azure SQL Managed Instances, since Azure manages the SQL Server instance memory.
Recommended Resources:
- https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16
- https://www.mssqltips.com/sqlservertip/4182/setting-a-fixed-amount-of-memory-for-sql-server/
- https://www.brentozar.com/blitz/max-memory/
- https://sqlsolutionsgroup.com/sql-server-default-memory-settings/
Page Last Updated: 26 June 2025