November 10, 2005 at 2:29 pm
I am pretty sure that SQL Server architecture does not allow this however, I wanted to open a discussion to see if there is a way around this.
SQL Server 2000 Standard Edition on Windows 2000 Server. with 8 GB RAM
Let's say that you created 3 instances on the sql box. Can you allocate memory where each instance will only use 2GB RAM? Thus, each instance will have 2GB of RAM and 2GB RAM for the OS?
November 10, 2005 at 4:10 pm
easily done... just configure each instance with 2 gig via sp_configure
A.J.
DBA with an attitude
November 11, 2005 at 4:31 am
Unless you're using adv server most of your memory will be wasted I'm afraid.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply