sqlserver profiles between clusters

[Nick Barlow]

Hi all,

I am wondering how and if its possible to enable sqlserver probe profiles between active/passive nodes.
For example, add a shared profile to the cluster profile, as you would with an ntservice, and make it so the sqlserver profile (agent job failures) is activated when the node is active.
I have attempted to do this previously, without success.

Thanks

[Gregg Stillwell]

Hope this helps:
https://knowledge.broadcom.com/external/article?articleId=133518

[Nick Barlow]

Thanks.
I think that is slightly different to what I am after.
I want a sqlserver probe profile to follow the cluster, as an ntservices profile would

[Gregg Stillwell]

Hi Nick,

Not sure, but I attached a KB and the probe doc in case there is more info about sqlserver profiles.

https://knowledge.broadcom.com/external/article?articleId=113187

https://techdocs.broadcom.com/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

[Nick Barlow]

Thanks for the info.
sqlserver is mentioned in the documentation but it's just 2 bullet points. I was looking for further info, if it exists.

[David Michel]

In regards to your question, if it is possible, the above referenced release notes shows it is:

sqlserver

2-node Active/Passive N+1 node clusters if the profile names are unique

the typical are to use the latest probe versions, and deploy and setup the cluster probe first.

[Nick Barlow]

Yea. That's what I mean. That's the only information I can find on configuring sqlserver profiles within the cluster probe.

Thanks