December 21, 2003 at 8:17 am
I would also like to hear about any results from testing this. The thread kind of lost focus, so I'll bring it back by simply asking how much memory can SQL Server 2000 Enterprise Edition use when running on a Windows 2003 Enterprise Edition server? Do you have to use 3GB/PAE/AWE or any other method to use all memory, or does it simply use all the memory the OS can give it (which as I've understood it is 32GB (http://www.microsoft.com/windowsserver2003/evaluation/features/highlights.mspx#32ram).
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Contributor to Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)
Articles: http://www.sqlservercentral.com/columnists/chedgate/
December 21, 2003 at 8:35 am
quote:
How much memory can SQL Server 2000 Enterprise Edition use when running on a Windows 2003 Enterprise Edition server?
32GB, the maximum supported by that OS.
quote:
Do you have to use 3GB/PAE/AWE or any other method to use all memory, or does it simply use all the memory the OS can give it (which as I've understood it is 32GB).
You need to enable AWE and use /PAE. Do not use /3GB with more than 16GB of memory, as the OS needs more than 1GB of kernel mode memory address space to manage that much AWE memory. (This means that the actual amount of memory used by SQL Server will be less than 30GB.)
--Jonathan
--Jonathan
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply