December 22, 2008 at 10:16 am
Ok, hopefully this is a basic question. How much RAM can SQL Server 2000, Enterprise Edition utilize on Windows Server 2003 Enterprise?
December 22, 2008 at 10:27 am
That depends on the max limit you've set on ur database which should be less than or equal to the max limit set by Microsoft. It keeps on adding and releasing memory based on requirements but cannot be more than 'max server memory'
My OLD BOL says its 64 GB for Windows 2000 DataCenter Server. No reference to 2003 server.
December 22, 2008 at 10:30 am
Ok, to clarify my question......
I am running SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise x64. Of coruse, SQL Server is x32 since there is no x64 SQL Server 2000. Is there any way, in this scenario, that SQL Server 2000 can use more than 8GB of RAM (with AWE enabled of course).
December 22, 2008 at 10:54 am
Hmmm... never tried that buddy. was browsing through Microsoft's web-sites and found few links.
2000 BOL
When awe enabled is set to 1, AWE memory is used, and the instance can access up to 8 GB of physical memory on Windows 2000 Advanced Server and 64 GB on Windows 2000 Data Center.
------------------------
http://support.microsoft.com/kb/899761
If Address Windowing Extentions (AWE) support is enabled, a single instance of SQL Server 2000 can only use a maximum of 50 percent of the physical memory that is on the computer.
This contains a hotfix to resolve this issue.
Another link containing useful info.
http://support.microsoft.com/kb/274750
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply