2 Node SQL Cluster, Instance on Each Node -- sql server clustering

Rodney R. Fournier [MVP]
4/19/2005 9:16:25 PM

Yes, you can. This is allowable.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog

[quoted text, click to view]

Mike Epprecht (SQL MVP)
4/20/2005 12:01:04 AM

In effect, you could run 8 instances on each node, with a maximum of 16 per
cluster.

Just make sure you configure SQL Server to not use all the memory on one
node, as during a failover, the other instance needs RAM too.

Regards
Mike

[quoted text, click to view]

Geoff N. Hiten
4/20/2005 9:54:49 AM

As Mike and Rodney indicated, you can run up to 16 instances on a cluster
and divide them however you choose. To choose, you set the preferred host
order for each SQL resource group using the cluster admin tool. As Mike
warned, you must plan for all instances to "collapse" onto a single node
duriing a failover situation.

Here is a useful KB article that covers Memory allocation on a cluster along
with a lot o other very good topics.

Clustered SQL Server do's, don'ts, and basic warnings
http://support.microsoft.com/default.aspx?scid=kb;en-us;254321

Geoff N. Hiten
Microsoft SQL Server MVP

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : 2 Node SQL Cluster, Instance on Each Node