SQL Server Performance

maximum memory for SQL 2000 on Win 2k3

Discussion in 'Getting Started' started by rpzhao, Jul 23, 2007.

  1. rpzhao New Member

    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
  2. MohammedU New Member

    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.
  3. rpzhao New Member

    Thanks MohammedU for the links
  4. satya Moderator

    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.

Share This Page