Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Clustering Question Expand / Collapse
Posted Tuesday, June 25, 2013 12:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:03 AM
Points: 1, Visits: 31
We hv 8 nodes in sql server clustering,
1) Let say now active node is failed in this case now which node will be active ?what are the parameter for this process? How it will decides ?
2)In clustering if one server fails then user can access from another server but how the dba know about that
3) What will be process to update patches in above scenario ?
3) No of concurrent connections in Active/Active or Active/Passive clustering mode ?
4) What is Virtual IP address in SQl Server clustering,?

Any explanation is highly appreciated.

Post #1466997
Posted Tuesday, June 25, 2013 4:13 AM


Group: General Forum Members
Last Login: Yesterday @ 9:28 AM
Points: 2,189, Visits: 6,013
The question should be posted in a different forum, because it has nothing to do with Integration services. As for your questions:

1) You can configure each group which node can be it's owner and also which node is the preferred owner.
2) You can check the value of serverproperty(' ComputerNamePhysicalNetBIOS'). Each time that it changes, you had a failover.
3) You can find the answer here –
4) Number of concurrent users has nothing to do with clustering. It is determined by SQL Server's configuration option – " user connections".
5) You can access any SQL Server (clustered and none clustered) by its name or by its IP. When you have a clustered SQL Server, you don't know on which node it will be at any time. If you'll use in the connection string the real name or real IP of the server that holds the SQL server at that time, after failover you'll have to modify all the connection strings. In order to avoid that, you have to work with virtual name or virtual IP that will get you to the cluster service which will send the connection to the active server. Virtual name is the cluster's name and the virtual IP is the cluster's IP.


To know how to ask questions and increase the chances of getting asnwers:

For better answers on performance questions, click on the following...
Post #1467063
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse