How to manage memory for SQL 2005 x64 on 64-bit WS2003 Ent

5 pts.
Tags:
Database
Memory
Microsoft Windows Server 2003
Server management
SQL Server 2005
I have a Windows 2003 Enterprise 64-bit server running SQL 2005 x64 with 32GB RAM. The SQL database is acting as a transaction database. What is the best way to manage memory on this server? Should I adjust the paging file? If so, to what? Any ideas are appreciated!

Answer Wiki

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

The goal with SQL Server is to not use the page file at all. If SQL needs to page data out then additional RAM should be installed as accessing data within the page file is typically as slow or slower then accessing it within the database files directly.

If you have SQL Server 2005 Enterprise Edition you can set the Lock Pages in memory setting to prevent SQL Server from using the page file, which is typically recommended. SQL Server 2005 Standard edition and below do not recognize this setting.

It’s currently recommended that you set your maximum memory setting for 75% of your physical memory. Another maximum memory setting is that you set the setting for 2-4 Gigs below your physical memory. You’ll need to try both settings and see which works better for you under your workload.

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

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