SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Clustering Question


Clustering Question

Author
Message
maddy.manvendra
maddy.manvendra
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 31
Hi,
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.

Thanks
Adi Cohn
Adi Cohn
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7693 Visits: 6594
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 – http://blogs.msdn.com/b/cindygross/archive/2009/06/10/sql-server-2005-clustering-tips-references.aspx
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.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search