topic Re: MSSQL Always-On Availability Group in Splunk AppDynamics

MSSQL Always-On Availability Group

Osama_Abbas — Wed, 06 Mar 2024 17:49:07 GMT

Hi community,

I have an AO AG with two nodes, and I have these four IP addresses.

10.10.10.62 (DB 1)
10.10.10.63 (DB 2)
10.10.10.61 (Cluster IP)
10.10.10.60 (AG Listener IP)

I want to discover the two nodes automatically. According to the documentation, Configure Microsoft SQL Server Collectors (appdynamics.com)

To enable monitoring of all the nodes, you must enable the dbagent.mssql.cluster.discovery.enabled property either at the Controller level or at the agent level.

I am running the following:

$ nohup java -Dappdynamics.agent.maxMetrics=300000 -Ddbagent.name=DBMon-Agent -jar db-agent.jar -Ddbagent.mssql.cluster.discovery.enabled=true &

But it doesn't work when I configure the collector with the AG Listener IP.

I also get the below: `Is Failover Cluster Discovery Enabled: False`! I have added dbagent.mssql.cluster.discovery.enabled though!?

What could I possibly be doing wrong?

Thank you

Re: MSSQL Always-On Availability Group

iamryan — Fri, 08 Mar 2024 18:30:08 GMT

Hi @Osama.Abbas

I noticed the Community has not yet jumped in to help. Did you happen to make any discoveries or find a solution you could share?

Re: MSSQL Always-On Availability Group

Osama_Abbas — Sat, 09 Mar 2024 09:55:47 GMT

Hi @Ryan.Paredez ,

Unfortunately, I have not found any resolution for my issue just yet and it is not clear in the documentation how to use:

dbagent.mssql.cluster.discovery.enabled

from the Controller UI.

Thank you,

Osama

Re: MSSQL Always-On Availability Group

iamryan — Mon, 11 Mar 2024 17:30:45 GMT

Hi @Osama.Abbas,

I have shared your feedback with the Docs team. I will report back when I hear from them.

Re: MSSQL Always-On Availability Group

iamryan — Thu, 21 Mar 2024 16:18:45 GMT

Hi @Osama.Abbas,

I'm still waiting to hear back from the Docs team. Have you found a solution you could share in the meantime?

Re: MSSQL Always-On Availability Group

Osama_Abbas — Tue, 26 Mar 2024 20:34:03 GMT

Hi @Ryan.Paredez

Thanks a lot for following up with my question. I really appreciate it.

Unfortunately, I was not able to solve it on my own till now and I had to discover just the primary node as a workaround until I can find a solution to my problem.

Thanks once again

Re: MSSQL Always-On Availability Group

iamryan — Wed, 27 Mar 2024 16:01:53 GMT

Hi @Osama.Abbas,

Thanks for letting me know. I'm still working with the Docs team to see if we can get any information on that Docs page clarified.

Re: MSSQL Always-On Availability Group

Ricardo_Guzman — Sat, 16 Aug 2025 06:55:30 GMT

Hola!

puedes intentar con:

-Ddbagent.mssql.cluster.discovery="true"

en el archivo de configuración:

\bin\DatabaseAgentService.vmoptions

(Si no existe este archivo, puedes crearlo)

Y me comentas si te funciona, Saludos!