Home Forums SQL Server 2008 SQL Server 2008 High Availability Pros and cons of having multiple instances on a Active Passive and Active\Active cluster RE: Pros and cons of having multiple instances on a Active Passive and Active\Active cluster

  • September 12, 2012 at 2:43 pm

    #1536919

    wannabe dba (9/12/2012)

    Hi guys,

    I have a sql 2008 r2 enterprise box which is running on windows 2008 R2 enterprise and the business wants to separate some of the databases from this instances and the recommendation that has been given to me is to have another sql instance installed in the Active\Passive cluster and move the databases over.

    What do you guys think are the pros and cons on this set-up?

    You typically move to multi instances when you have a requirement for

    • different security requirements
    • ring fencing a "we require god rights" vendor
    • different service pack levels

    wannabe dba (9/12/2012)

    Eventhough the new instance wwill have its own cluster group wouldn't it share the processor and ram?

    Yes it would but you can restrict these resources at each instance level

    wannabe dba (9/12/2012)

    Wouldn't an issue with one of the partitions cause both the instances to fail over?

    Your input will be greatly appreciated.

    No, the shared disks are unique to each instance. A disk issue for instance A would have no effect on instance B.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉