October 29, 2009 at 8:58 am
Hi
I have a 2 node windows 2003 cluster. In the cluster I currently have 2 virtual machines SQL2000 and SQL 2005 (I think you can guess what they are for!)
My boss wants to add an SQL2008 instance for a CRM project.
Each node has 2x quad core processors and 16gb ram.
The sql2005 virtual is set to take 4 cores and 12gb ram, the SQL2000 takes 2 cores and 3 gb. The rest is used by the cluster.
Question 1: If I add another instance for sql2008 that takes 4 cores and 12gb mem and run it on the same node as SQL2000 that should be okay. If it were to fail over what would happen to the resources. Would sql2008 take priority of the reamining resources or would it be first come first served?
Question 2 : MSDTC would this be okay running 1 msdtc between 3 instances? Would it cause any problems?
November 29, 2009 at 4:11 pm
Question 1: If I add another instance for sql2008 that takes 4 cores and 12gb mem and run it on the same node as SQL2000 that should be okay. If it were to fail over what would happen to the resources. Would sql2008 take priority of the reamining resources or would it be first come first served?
The resources will be taken by the first instance that needed them. you should distribute the resources manually and before to make a failover.
Question 2 : MSDTC would this be okay running 1 msdtc between 3 instances? Would it cause any problems?
There is not problem, just make a test process before to release to PROD.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply