setup maximum and minimum memory

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » setup maximum and minimum memory

setup maximum and minimum memory

Rate Topic

Display Mode

Topic Options

Author

Message

sqlfriends

Posted Sunday, November 18, 2012 6:51 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:13 PM
Points: 1,610, Visits: 2,794

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

Post #1386124

SQLSeTTeR

Posted Sunday, November 18, 2012 6:53 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 192, Visits: 867

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.

Post #1386125

Vedran Kesegic

Posted Monday, November 19, 2012 12:28 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 343, Visits: 1,076

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.

_____________________________________________________
XDetails Addin - for SQL Developers and DBA
blog.sqlxdetails.com - Transaction log myths - debunked!

Post #1386180

Bhuvnesh

Posted Monday, November 19, 2012 2:04 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1386217

« Prev Topic | Next Topic »

Permissions