How to make use of 4 GB memory for SQL server 2005 standard + Windows 2003 stardard

Posted on 2007-07-30
Medium Priority
Last Modified: 2008-09-19
We just upgraded the memory of our database server from 2GB to 4GB. And its OS is windows 2003 standard and sql is 2005 standard edition. According to microsoft(http://msdn2.microsoft.com/en-us/library/ms143685.aspx and http://msdn2.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003), this configuration should allow database use up to 4 GB memory. My question is : Do I need to do anything(such as: adjust the maximum memory in management studio)  to let our server be able to consume this extra 2 GB memory?  
Question by:pumaken68

Expert Comment

ID: 19597387

Read above,  Yes you do... if you want SQL to use more than 4 GB of RAM..


Author Comment

ID: 19597718
Thanks CvV.
Actually I read this article somewhere in this forum yesterday. But it only mentions it's for SQL server 7 and 2000. Are you sure it applies for SQL server 2005 as well?
Because when I check the maximum memory supported for SQL server 2000 editions at http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx. It only says maximum 2 GB with windows 2000 server. While maximum memory supported for SQL server 2005 standard on windows 2003 standard is 4 GB already. That's why I doubt that article could applies for SQL 2005.
LVL 30

Accepted Solution

nmcdermaid earned 500 total points
ID: 19597818
I'm not sure how you make it use 4G but I do know you want to save 1G for the operating system. Therefore if your server has 4G, let SQL use 3G and save 1G for the operating system.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question