SQL Server Performance Forum – Threads Archive

maximum memory

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.

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.

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
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

]]>