Post reply

Clustering Question

  • June 25, 2013 at 12:44 am

    #295064

    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

  • June 25, 2013 at 4:13 am

    #1627045

    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%5B/URL%5D

    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/

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

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