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

SQL 2012 Cluster Multiple Instances Procedure ! Expand / Collapse
Author
Message
Posted Tuesday, March 26, 2013 3:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 8, 2013 1:26 AM
Points: 1, Visits: 4
Hello,

Kindly help me if I need different sources for each instance or can I use the same for all the instances I want to install like, SAN Driver, IP Address, Service Account?

Kindly give me the detailed procedure to follow as in Best Practise.

Regards !
Post #1435349
Posted Wednesday, March 27, 2013 5:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:52 AM
Points: 5, Visits: 94
As per my understanding of your question, you need information on building and configuring a Multiple Instance cluster.
The cluster can have multiple instances installed and for good performance, it is important to run instances on different physical nodes. So if you have Instance A and B then run instance A on node1 and InstanceB on node2. So that they can use each node resources.

Also, every instance on cluster will have their own IP address and dedicated SAN drives.
The SQL services can run with the common account, that is not a problem.
Post #1435829
Posted Friday, March 29, 2013 3:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:37 AM
Points: 6,174, Visits: 13,317
Asim 6451 (3/26/2013)
Hello,

Kindly help me if I need different sources for each instance or can I use the same for all the instances I want to install like, SAN Driver, IP Address, Service Account?

Kindly give me the detailed procedure to follow as in Best Practise.

Regards !

Each instance you install will have its own resources such as storage, IP and virtual networkname. I would also use dedicated service accounts for each service too. A SQL Server 2012 cluster deployment is not a great deal different to 2008 R2 so this guide should be helpful

Part1
Part2
Part3


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1436849
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse