sqlserver probe keeps crashing when the database moves to another node

book

Article ID: 107806

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction



We have an MS SQL Always On Group (AAG) that is being monitored by the sqlserver probe however the probe crashes when the database moves to another node in the group. 

Environment

Release: CNMSPP99000-8.47-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component:

Resolution

Ensure that the probe is monitoring the AAG group/virtual name rather than individual nodes.
For cluster failover monitoring the sqlserver probe can be used in conjuction with the cluster probe.
Review the documentation for both probes for further information..