1.May I please know, do we directly fetch any data related to database from Database
2.Do we get all data we get are from applications servers where dynatrace agents installed.
3.Even though DB not configured in APPMON it shows database also in monitoring page. How?
4.How appmon creating database and database hotspot dashlets.
DB Hotspot details are fetched from DB or application servers.
Thank you so much in advance.
Solved! Go to Solution.
In AppMon, we monitor the Database indirectly by default. This means that you don't need an agent to understand the performance of the database. Simply by monitoring the processes which are making calls to the database (e.g. via the JDBC or ADO sensor packs) it is enough to have a view of every query (both SQL and NoSQL) that is made against the database, understand if there have been any errors, and how long it took to execute each of them. Based on the code layer making the calls, AppMon recognises the call as a database query, takes note of the connection string, and records this as a database instance; these instances are then showed in the Database and Database Hotspots dashlets. With this approach, however, we cannot deliver infrastructure health metrics the way it's possible when an agent is installed on the server.
There is also the possibility of a more in depth monitoring of the Database with the database agent. This will go directly to the database and query the admin level tables of the database to provide you with a live view of the database health.
More details about these approaches and the database agent are available here