How can we delete the duplicated database backend servers

[Frank_Feng]

Hi there,

We are using AppDynamics to monitor the j2ee applications, currently in the databases backend servers, we have a couple of same oracle database backend servers. I tried to delete others, only keep one up, but they come back later. please see the attached screen shot.

Note:

LNX1001 is our database host.

we have many different schemas running on the same host LNX1001.

[Arun_Dasetty]

Hi,

Deleted backends will rediscover again when new load is generated for same backend and this is feature, If you do not want any backend already discovered disable the auto discovery rules and define custom backend rules as stated in doc link : https://docs.appdynamics.com/display/PRO39/Configure+Backend+Detection

Once you disable the auto discovery JDBC rule and if you delete now the backend deleted will not rediscover, Hope that clarifies the product functionality.

Regards,

Arun

[CommunityUser]

Hi There

I would like to quote what you have said about "Deleted backends will rediscover again when new load is generated for same backend and this is feature, "

1*If i would like to monitor a database, through AppDynamics Pro only , do i have to install an agent ? doesn't it monitor it remotely like Appdynamics for Database ?

2* what is the advantage if i am going to install an agent to monitor the database ? I mean isn't it enough that whenever there is a load on the application it will show me the SLOWEST calls etc.... ? or does it provide more visibility over the application ?

I am on trial version now, and i would appreciate your fast response.

[Arun_Dasetty]

Hi,

Please find my response inline:

>>>>>> 1*If i would like to monitor a database, through AppDynamics Pro only , do i have to install an agent ? doesn't it monitor it remotely like Appdynamics for Database ?

Answer:  You do not need to install any software on actual physical instance to monitor a database server either using AppServerAgent (java) Or .Net iis agent Or using db-agent.jar (DB Mon 4.x) agent which is ad4db latest version of agent specific to monitoring database server

Java/IIS agents which runs inside JVM/IIS will use java/iis internal api to gather database stats , say javax.sql.* api to get data base name, execution time etc, and the ad4db issues some queries to gather database server specific statistics from remote machine where jvm/iis server or ad4db/dbafgent.jar is running, Hope that clarifies your query and sends data to contrller UI server.

>>>>>> 2* what is the advantage if i am going to install an agent to monitor the database ? I mean isn't it enough that whenever there is a load on the application it will show me the SLOWEST calls etc.... ? or does it provide more visibility over the application ?

Answer: Using AppServerAgent(JVM)/IIS agent we will gather SQL queries part of business transactions only and also we will gather stats like total calls to db, ARTms, errros , CPM, etc only as refered in doc https://docs.appdynamics.com/display/PRO39/Monitor+Databases#MonitorDatabases-DatabasesList

refer doc https://docs.appdynamics.com/display/PRO40/Database+Monitoring

However using AD4DB or later version of db-agent.jar you will in details db level stats and h/w stats like CPU, Memory in addition to sql level stats like session , clients id , top queries (where app server shows only top 10 queries but db agent shows top 100 as per my understanding)

https://docs.appdynamics.com/display/PRO40/Install+or+Upgrade+the+Database+Agent

[CommunityUser]

Thanks alot Akumar , does appdynamics support ERP and SAP via citrix ?