Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Setup multiple SQL Instance in the same cluster Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 9:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 22, 2014 7:53 AM
Points: 4, Visits: 41
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?
Post #1386453
Posted Tuesday, November 20, 2012 6:00 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 28, 2014 8:49 AM
Points: 862, Visits: 374
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
Post #1386874
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse