SQL Server Performance

maximum memory

Discussion in 'SQL Server Clustering' started by shahab03, May 24, 2006.

  1. shahab03 Member

    whats the maximum memory that sql server 2000 can utilize on windows 2003 cluster? right now I have 4 GB memory and having resource issues.
  2. Luis Martin Moderator

    What SQL version?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. ghemant Moderator

    Hi,
    SQL Server Standard Edition supports upto 2 GB Memory and if you wants to utilize more than 2 GB Memory you have to use SQL Server Enterprise Edition.
    Refer "maximum capacity specifications" in BOL for more information.


    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

Share This Page