September 2, 2020 at 4:15 pm
We have a SQL 2012 Server that had the Maximum Server Memory set about 8 months ago. We started to receive timeout errors from our applications and when we looked at the Maximum Server Memory it appeared to have reverted back to the default setting.
Is there any process, such as a patch, update, or other system function that could have reset this without our knowledge?
Thanks in advance for any help.
September 2, 2020 at 9:06 pm
I very highly doubt it and not aware of any such thing. That would certainly break a lot of systems if that could happen. No one may remember doing it specifically in SSMS but it could have been done accidentally by someone doing something like playing with dbatools and testing the command to set max memory. Or finding some script and running it...without fully reading and understanding what it really does. People do that way too often.
Sue
September 2, 2020 at 10:22 pm
Sue_H,
Thank you for your response. I didn't see how anything could change it outside of someone manually changing it. I appreciate your response and insight.
September 3, 2020 at 4:07 pm
I'd agree with Sue
September 7, 2020 at 10:10 pm
A message is put in the SQL Server Log when it is changed that says what the old and new values are e.g.
Configuration option 'max server memory (MB)' changed from 16000 to 15999. Run the RECONFIGURE statement to install.
If you keep a reasonable amount of logs you can use the filter option to search for 'max server' and at least find out when it was done.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply