What is the RAM limit on SQL Server 2005 32-bit, when running on a 64-bit OS?

Posted on 2011-10-03
Last Modified: 2012-06-27
The title says it ...

This suggests it's 4GB ... but the arguments over /AWE lost me:

I can't find it on an MS site.

Question by:Daniel Wilson
    LVL 3

    Assisted Solution

    The memory limit for SQL Server 2005 32-bit is the Operating System maximum, according to Microsoft:

    So, for example, on Windows Server 2008 Standard 64-bit, the limit would be 32 GB:
    LVL 7

    Accepted Solution

    LVL 38

    Assisted Solution

    by:Adam Brown
    AWE is a SQL server option that allows you to address memory based on server limitations rather than the SQL server's limitations. This is a function that is only available to Enterprise and Datacenter versions of Windows 2003/2008, from what I can tell. has an explanation of what AWE is and how to configure it. Basically, it allows you to bypass the limitations of the x86 version of SQL. But the link you give is accurate about memory addressing by default in SQL x86. You can't address more than 4GB of memory in a 32-bit version of SQL without enabled AWE.
    LVL 32

    Author Closing Comment

    by:Daniel Wilson
    Thank you all!

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
    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 tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

    745 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

    12 Experts available now in Live!

    Get 1:1 Help Now