November 18, 2012 at 6:51 pm
I have a dedicated SQl server that has 12 gb physical memory.
I manually change the default max memory to 8.5 GB(8704).
Do I need also to setup minimum memory?
for example to 1 GB(1024)?
Thanks
November 18, 2012 at 6:53 pm
The min server memory server configuration option can be used to ensure that SQL Server does not release memory below the configured minimum server memory once that threshold is reached. This configuration option can be set to a specific value based on the size and activity of your SQL Server. If you choose to set this value, set it to some reasonable value to ensure that the operating system does not request too much memory from SQL Server, which can affect SQL. Hope this help.
November 19, 2012 at 12:28 am
Are there other applications/sql instances on the server ? 8.5GB is too low if your instance is alone on the server.
Min server memory is not so important to set, especially do not set it high. Maybe if your sql instance is competing with other apps for the server memory.
November 19, 2012 at 2:04 am
sqlfriends (11/18/2012)
I have a dedicated SQl server that has 12 gb physical memory.
then MAx memory can go upto 10 gb
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply