Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
This question already has an answer here:
I have never changed this setting for an AlwasyOn setup. What is the best practise to do this? Should I change the setting on the Secondary node first and then the primary? Please suggest . The current setting is set to the default max value and that is something not which I want. Each of the server has 24gb of memory. The total size of the databases on each node is 105gb
Thanks
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
The current setting is set to the default max value and that is something not which I want.
You should change your max memory setting away from the default. Its a dynamic setting that does not require a restart of sql server service. Bear in mind that running reconfigure it will flush out the plan cache.
Refer to my answer here for more details.
Each of the server has 24gb of memory. The total size of the databases on each node is 105gb
Start with 21GB as max memory provided you are running only SQL Server (no SSIS, SSRS, SSAS,etc). Leave 3 GB for OS.
Depending on the database activity, the RAM (24GB) seems to be low. You should look out for low memory notifications to see if server is having memory pressure.
