June 17, 2004 at 9:49 am
I know that SQL Server 2000 Standard is limited to 2GB RAM on Windows 2000 Server Standard, but I have two questions:
1) If two instances of SQL Server 2000 Standard are running on Windows 2000 Server Standard Edition with 4GB RAM, can each instance use up to 2GB?
2) Does the answer to the first question change if the operating system is Windows Server 2003 Standard, which is also limited to 4GB?
Thanks,
Chris
June 17, 2004 at 10:01 am
That is true. Each instance of SQL would be considered as a separate instance of application and can take upto 2 GB. of space. (It would only take upto 1.7 GB as you need memory for Kernel/System )
June 17, 2004 at 10:53 am
Yes, each can use 2GB, but you need to save some for the OS, I'd say 500MB or so, so really 1.7GB or so per instance.
And you should set the values for each instance when you have more than one, don't let them dynamically compete.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply