2 different version instances on one server

Last Post 29 Mar 2010 05:37 AM by russellb. 5 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
trans53
New Member
New Member

--
22 Mar 2010 07:00 PM
Hi guys,

I have 2 instances running on one node (Windows 2008 Enterprise).

First instance is sql 2005 32 bit and secod instance is sql 2008 64 bit.

Now sql 2005 has 2GB max fixed memory assigned and i am wondering if we can do \3G switch so sql 2005 will have 3GB instead but i am not sure if it's possible. Any thoughts on this?
rm
New Member
New Member

--
23 Mar 2010 03:24 AM
Has 64-bit OS? How much memory does the server have?
trans53
New Member
New Member

--
23 Mar 2010 07:07 AM
Yes, OS is 64-bit and it has 24GB of memory available.
gunneyk
New Member
New Member

--
23 Mar 2010 01:36 PM
With a 64 bit OS you can enable the /3GB switch and it will actually allow you to use 4GB instead of 3GB. This is a bonus of running under a 64 bit OS.
trans53
New Member
New Member

--
23 Mar 2010 02:36 PM
i did not know about this, thank you!
russellb
New Member
New Member

--
29 Mar 2010 05:37 AM
make sure to set the max memory on the 64x instance so it doesn't starve the 32x instance for memory too


Acceptable Use Policy
---