Tuesday, 27 December 2016

setting MAXMEM on servers in an Always On group


  1. No restarts required
  2. Use the following to set MAXMEM to 60GB (SQL had 64GB RAM so we left 4GB for the OS)

Enable advanced options:
USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE

Set the maximum amount of memory to 64 MB:
USE master
EXEC sp_configure 'max server memory (MB)', 
61440
RECONFIGURE WITH OVERRIDE

Then refresh SSMS and review updated value in Properties



No comments:

Post a Comment