DX Unified Infrastructure Management

 View Only
  • 1.  sqlserver profiles between clusters

    Posted May 11, 2022 06:38 AM
    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


  • 2.  RE: sqlserver profiles between clusters

    Broadcom Employee
    Posted May 11, 2022 08:06 AM
    Hope this helps:
    https://knowledge.broadcom.com/external/article?articleId=133518


  • 3.  RE: sqlserver profiles between clusters

    Posted May 11, 2022 08:15 AM
    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


  • 4.  RE: sqlserver profiles between clusters

    Broadcom Employee
    Posted May 11, 2022 08:36 AM
    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


  • 5.  RE: sqlserver profiles between clusters

    Posted May 18, 2022 04:44 AM
    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.


  • 6.  RE: sqlserver profiles between clusters

    Broadcom Employee
    Posted May 18, 2022 08:32 AM
    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.


  • 7.  RE: sqlserver profiles between clusters

    Posted May 20, 2022 04:33 AM
    Yea. That's what I mean. That's the only information I can find on configuring sqlserver profiles within the cluster probe.

    Thanks