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

SharePoint Information Architecture Diagram

Here is the template I use for Information Architecture designs. It's built using Mindjet and I flesh the nodes out with the low level d...