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

Posted on 2007-07-30
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( and, 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
    LVL 5

    Expert Comment


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


    Author Comment

    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 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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now