Hi. What are opinions on setting Min Server Memory? I'm aware that setting it equal to Max Server Memory is not a good idea. But our department says we should leave it at 0 citing:
Either leave it at 0 or set both min and max to the exact size you want, which can result in better overall performance.
Thankyou.
A similar question would be - is there anything to lose by setting the Min Server Memory to non-zero. Especially when it's only one instance on the Server.
In theory, yes, you get better performance using "Lock Pages In Memory" option, which is best with a fixed amount of RAM specified.
Interesting... Why don't you agree with Erik Darling on why he says that setting them both to the same number is a really bad idea?
Again... interesting... do you happen to have a favorite link on the subject?