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
We can provide some answers but with the questions you have you need to do some reading too. HEre is a link to MSDN page about clustering.
http://msdn.microsoft.com/en-us/library/hh231721.aspx. You really need to take the time and read through it. Now to your questions. 1. If a node in the cluster becomes unavailable/unresponsive then the cluster will fail over to the next one specified on the Failover Cluster Manager. Choose a specific instance and open "Properites". The general tab should show the "Preferred Owners". Chose the server(s). There is also an "Advanced Policies" tab the allows for specifying "Possible Owners". It "decides" to failover based on the specifications for resources available. You can also specify different servers for different instances. If you have 8 server. Server 1 could failover too Server 5. Server 2 could failover too server 5 or 6. 2. The DBA will know by either documenting the process or viewing Failover Cluster Manager. 3. Patching is a fairly straight forward process. Basically you apply to a node where there aren't any instances residing. Then fail instances over to patched instance. Read more here.
http://support.microsoft.com/kb/958734 The other answers can be found in the information links provided.