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

    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

    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.


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

Share This Page