Enabling more than 2 gigs of memory...
-
Good day,
I have a server (Windows server 2003 SP1) that I have SQLServer 2005 developer loaded on. This server has 4 gigs of memory, and the boot.ini shows that the /3GB and /PAE are enabled. In the properties of the SQL Server, under memory, I have enabled the AWE to allocate memory, however, I cannot increase the memory past the 2 gigs that it is listed at. What may I be missing? I have seen the following that states I should be able to do this:
| Win2KSE | Win2KEE | Win2K3SE | Win2K3SE x64 | Win2K3EE x64
------------------------------------------------------------------------
SQL2000SE | 2 | 2 | 2 | 2 | 2
SQL2000EE | 2 | 3 | 3 | 4 | 4
SQL2005SE | 2 | 3 | 3 | 4 | 64
SQL2005EE | 2 | 3 | 3 | 4 | 64
SQL Server 2000 Enterprise Edition and Windows 2003 Standard Edition willallow SQL Server to use 3GB of RAM if you boot with the /3GB switch.
Windows 2000 Standard doesn's support the /3GB switch, and SQL Server 2000
Standard is limited to using 2GB of RAM.
SQL Server 2005 Standard Edition and Windows 2003 Standard Edition will
allow SQL Server to use 3GB of RAM. SQL Server 2005 Standard Edition and
Windows 2003 Standard X64 Edition will allow SQL Server to use 4GB of RAM.
Here's a matrix of SQL and OS combos indicating the maximum amount of
non-AWE memory available to SQL Server in GB:
Please help!?
Cory
-- Cory
-
Right, first off forget AWE and PAE - you only have 4GB memory. These features are to support memory beyond 4GB, remove any configuration settings you have for these features.
The /3GB switch is all that is required. By default with 4GB, windows reserves 2 for the OS, leaving 2 for SQL. This switch restricts the OS to 1, leaving 3 for SQL.
Developer edition has all the features of enterprise, so there are no limits other than licensing.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply