Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

setup maximum and minimum memory Expand / Collapse
Author
Message
Posted Sunday, November 18, 2012 6:51 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:00 PM
Points: 1,786, Visits: 3,237
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
Posted Sunday, November 18, 2012 6:53 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 10, 2014 7:53 AM
Points: 220, Visits: 1,163
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
Posted Monday, November 19, 2012 12:28 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, September 29, 2014 5:52 AM
Points: 369, Visits: 1,215
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.


_____________________________________________________
Microsoft Certified Master: SQL Server 2008
XDetails Addin - for SQL Developers
blog.sqlxdetails.com - Transaction log myths
Post #1386180
Posted Monday, November 19, 2012 2:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 6, 2014 5:46 AM
Points: 2,840, Visits: 3,969
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
Post #1386217
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse