Anyone know the maximum addressible memory for SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition? The only information I can find from Microsoft is for SQL Server 2000 on Windows Server 2000. SQL Server 2000 EE can support upto 64GB on Windows 2000 Datacentre edition. Windows Server 2003 Enterprise Edition can support 32GB of memory, can we assume that SQL 2000 EE on Windows 2003 EE can support 32GB as well? Thanks Rupeng Rupeng
http://www.sql-server-performance.com/awe_memory.asp http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1157395,00.html MohammedU. Microsoft SQL Server MVP Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
The same has been documented under Books online (updated) too in thsi case. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com @http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
