What does the min server memory setting actually mean?

Published On: 2007-10-17By:

I know that there is some confusion about what exactly the minimum server memory setting in sp_configure actually does.  When I was at PASS I was able to ask the Microsoft guys this very question and here is what they told me.

 The setting does not control how much memory SQL takes when it starts up.  What it controls is a low watermark as to how much memory SQL will keep. 

For example if you have 2 Gigs of memory installed, and a min memory setting on 1024 MB and a max memory setting of 1536 MB and Windows starts telling SQL that it needs more memory SQL will give the memory back until it hits the 1024 MB lower limit.  Once it hits that limit it will no longer give memory back to Windows.

 Denny


Contact the Author | Contact DCAC

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via