• sqlbuddy123 (7/21/2009)


    Hi Wayne,

    Here is an article which says that it's not recommended to have more than one instance installed on a single cluster node.

    http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

    Since you are saying that you have just 2 instances and that too being pre-prod databases, I stongly believe that you should not have any problems or issues with that implementation. To let you know, we have both Development and Production clusters with multiple instances sitting on each cluster node.

    Thank You,

    Best Regards,

    SQLBuddy.

    I don't agree with everything it says in that article, especially since it doesn't make the case for why it recommends what it does. What I do agree with is that you should do plenty of planning.... and if you come to the conclusion that your resources are sufficient to support your desired configuration, then go ahead and implement it.

    John