Setting up SQL Server 2005 memory

30 pts.
Tags:
SQL Server 2005 administration
SQL Server 2005 memory
SQL Server 2005 performance
My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set 'lock page on memory', but Task Manager show only 4.50GB only and performance monitor show SQL server manager - total memory on 4GB. Expert: Do I setup memory wrong?
ASKED: March 6, 2009  10:46 PM
UPDATED: June 26, 2013  5:45 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

SQL Server will only take the memory that it needs. If it needs 4.5 Gigs it will take 4.5 Gigs no more.

The min memory setting is a low watermark. Once SQL Server is using that amount of memory it won’t return memory back to Windows to go lower than that amount.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Maylee63
    Thank you very much.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following