MSSQL Always-On Availability Group

[Osama_Abbas]

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

[Ricardo_Guzman]

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!

[iamryan]

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. 

[iamryan]

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?

[Osama_Abbas]

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

[iamryan]

Hi @Osama.Abbas,

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

[iamryan]

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?

[Osama_Abbas]

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