Wednesday, June 19, 2013

Commands for getting cluster stats as well as Fail over information

Hello ,

Below listed commands ,we can use in SQL Cluster Environment instead of GUI.

1) View SQL Clusters

Run --> CMD
          cluster /list
 

2) View Status of Nodes

 
           cluster node 
            -or 
           cluster node /status
 

3) View the cluster Groups 

      
                    Cluster Group 
                         or 
                cluster Group /status

4) View Status of Cluster Networks

                    Cluster Network 
               or 
                 Cluster Network /Status
 
 

5) View Properties of All Network Interface Devices

 
                    Cluster netinfterface 
                         or
                    Cluster netinterface /status


6) View the listing of all available cluster resources.

 
             cluster resource 
                --or 
             cluster resource /status 
                 or
             cluster res

7) Fail over the resource to New node

           cluster group "groupname" /move:nodeName
 
 
 
Thanks
A.S.Reddy