nroberson (8/27/2012)
Unforunately, mgmt doesn't see it that way and I think I've convinced them it's not.
Doesnt matter what they believe, point of fact sql server does not provide load balancing through clustering. It can through merge replication but its frought with issues and still doesnt represent true load distribution, maybe they're thinking of Oracle RAC
nroberson (8/27/2012)
So if we have a two node multi-instance (what used to be called Active/Active) Cluster; you're saying that on one instance we should have the databases for Application A. On the second node, we should have the databases for Application B / Application C.
You refer to an instance, the first instance, but then you refer to a node instead of a second instance. You must think t the instance level, clustering is the Windows OS technology that sits underneath.
nroberson (8/27/2012)
Application A will use node 1, and Applications B & C will use node 2. If node 1 goes down, Application A will then switch over to use Node 2 until the problem is resolved and Node 1 is back online.If you have all your databases on one node, can you only have Active/Passive Clustering?
Again think at the instance level. Is there any reason why you are using 2 instances, different security requirements, etc?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉