Monitor one node from cluster only - not all nodes

• 
  Hi Michael,
  
  In version 5 we have made the default behaviour to automatically discover the cluster and all of its nodes by putting in any node of the cluster or the cluster name itself (see the documentation here: https://documentation.red-gate.com/disp ... to+monitor under step 3). The licensing is per Windows host machine so when you try to add the single node of the 2 node cluster it is attempting to add both nodes and unable to do so due to licensing issues.
  
  There is a work around that can be attempted but this is not officially supported. if you would like more information about this please contact support@red-gate.com

  Sarah B May 30, 2016 10:12

  - 0 +
• 
  Hi, I'm in a similar situation. One of my cluster node is off; but when I try to add the other node, it's failing because it's unable to connect to the other node which is disconnected. 
  
  Thanks,
  Justin

  justinjose02 May 18, 2022 21:58

  - 0 +
• 
  Hi Justin,
  It looks like a colleague was previously assisting you with this through a ticket that's since been closed through lack of response. A new ticket has been created and I'll message you shortly through our ticketing system as it would be beneficial to gain some additional logs that we don't want to post on public forum.

  Tom_C May 31, 2022 14:00

  - 0 +
• 

  The error that you are seeing indicates a firewall issue blocking the connectivity from SQL Monitor to the Cluster.

  The following link has more information on the this https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/preparing-for-adding-monitored-servers/adding-servers-on-a-different-network-from-your-base-monitor/summary-of-firewall-requirements 

  If the cluster is hosted on cloud, then the following link has details on setting up the inbound rules https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/preparing-for-adding-monitored-servers/adding-servers-on-a-different-network-from-your-base-monitor/machines-hosted-in-the-cloud

  If the issue persists, then please perform the following troubleshooting steps from the server hosting the Base Monitor
  

  Using an elevated command prompt to open wbemtest, then try connecting via WMI to \\<ClusterName>\root\MSCluster
  

  (ensure packet privacy is selected)

  

  
  

  Then query SELECT Name FROM MSCluster_Node and see if that node shows up?

  
  
  This will help pinpoint the issue.

  Tom_C May 31, 2022 14:04

  - 0 +
• 
  Hi Tom,
  
  Thank you for the reply. One of my node is off and monitor trying to connect to that node and throwing the 'not reachable' exception. It's not reachable because the node is off. Is there any other way we just monitor only available nodes?
  
  Thanks,
  Justin

  justinjose02 May 31, 2022 21:22

  - 0 +
• 

  Hi Justin,
  
  Apologies for the delayed response, not sure how this slipped through without response.
  
  If you want to stop monitoring these, suspending the instances on this node would probably be the best way to achieve if I've understood your question correctly.
  https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/managing-monitored-servers/suspending-a-monitored-server

  Please let me know if any issues.

  Tom_C June 27, 2022 12:33

  - 0 +
• 

  Sarah B said:

  Hi Michael,
  
  In version 5 we have made the default behaviour to automatically discover the cluster and all of its nodes by putting in any node of the cluster or the cluster name itself (see the documentation here: https://documentation.red-gate.com/disp ... to+monitor under step 3). The licensing is per Windows host machine so when you try to add the single node of the 2 node cluster it is attempting to add both nodes and unable to do so due to licensing issues.
  
  There is a work around that can be attempted but this is not officially supported. if you would like more information about this please contact support@red-gate.com

  Hi Sarah, If i understand correctly there's still a way by which we can choose to only add the primary node in the cluster in SQL monitor. I would like to understand how we can do that in newer version of SQL monitor.

  VijayRana June 26, 2023 07:26

  - 0 +

Add comment

Please sign in to leave a comment.