Setup multiple SQL Instance in the same cluster

  • Hi Guys, I have two SQL 2008R2 Enterprise servers setup in an Active/Passive cluster(running on Windows 2008R2 Enterprise server) with one SQL instance.

    I want to add two more SQL instance and another active SQL server node to the cluster(active/active/passive).

    My disk setup is:

    1 Shared Quorum disk

    1 Shared Data disk

    1 Shared temp disk

    1 shared Log disk

    Do i need anything else in order to add the additional instances?

  • You shall need additional Disk resources for each of your new instances Log, data, tempdb.

    You shall also require additional IP addresses both Private and Public, as well as ensuring there are free Network cards on the server for the additional IP addresses and a SQL Network Name for the new instances

    The SQLCAT team has a good article located at http://sqlcat.com/sqlcat/b/whitepapers/archive/2009/07/08/sql-server-2008-failover-clustering.aspx

    You will also want to ensure that Max Memory has been configured on each of the SQL instances and that in the event of a failover 1 Node can handle multiple resources

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply