We just bumped RAM from 16 GB to 48 GB on our physical SQL 2008 server. Do I need to change any Server memory options as the result? What is the proper number?
Currently we have:
Minimum server memory = 2048 mb
Maximum server memory = 12288 mb
Index creation memory = 0
Minimum memory per query = 1024 kb