how to monitor sql server failover events automatically ca UIM

[Roushan Kumar]

I have a sql server instance running on cluster node A which has it's failover on node B. Is there any option to setup monitoring to alert if it fails over to node B?

[David Michel]

check out the sqlserver probe metrics page
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-metrics.html

and cluster probe
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/cluster-clustered-environment-monitoring/cluster-clustered-environment-monitoring-release-notes.html#concept.dita_cb3bd01270092335707fda87ec67df8a122cbe38_SupportedProbes

------------------------------
Support Engineer
Broadcom
------------------------------

[Jay Wink]

The Cluster probe is great to use for many things.  The ntevl probe is great for Cluster faults.  You can pickup all kinds of things in the Windows Event Logs as it relates to the cluster having issues or failing over.

------------------------------
Customer Success Architect
Broadcom
------------------------------