This page applies to an earlier version of the AppDynamics App IQ Platform.
See the latest version of the documentation.

Skip to end of metadata
Go to start of metadata
AppDynamics Pro Database Monitoring goes beyond the backend database detection in AppDynamics Pro application monitoring to give you end-to-end visibility into the performance of your application, helping you dramatically reduce the time it takes to find and fix database performance issues.

Use AppDynamics Database Monitoring to monitor your databases and database servers for situations you need to be aware of, whether it be load that is too high, response time is too slow, number of executions of a SQL queries are too high, or disk capacity is too low. Using the power of AppDynamics Pro, AppDynamics Database Monitoring monitors your databases 24/7 automatically and can alert you when unusual or critical situations arise.  AppDynamics Database Monitoring provides an intuitive interface on a single pane of glass that visualizes database and server activity so you can see at a glance where problem areas are. 

You may want to run multiple Database Agents reporting to the same Controller for the following reasons:
  • You can run additional backup Database Agents that take over for your primary Database Agents in case the primary ones go offline, ensuring your databases are continually monitored despite agent failure or during planned machine downtime. The additional Database Agents can run on the same machines as the primary Database Agents or on different machines.
  • You can have an agent in each distinct network of your environment. Since the agent requires network access to the database, you may need multiple agents to monitor all the databases in your environment.
  • You can have multiple Database Agents running under different user accounts on the same machine, which is particularly useful if you want to monitor SQL Server via Windows Authentication as various users.

How AppDynamics Monitors Databases

AppDynamics Database Monitoring takes a time-based approach to monitoring, providing you with visibility of the database performance over time. You can see the current performance of connected sessions, drill down into SQL Explain plans and view database statistical information. You can see what is happening now as well as what occurred over the last day, the last week or the last month. The product answers important questions such as “What happened to the online application yesterday to make it slow down?” and “Why is the overnight batch job still running this morning at 8:55?”

AppDynamics Database Monitoring sorts database activity by efficiency, showing you the worst performing activities. You can immediately see potential problems, such as which SQL statement or stored procedure is consuming system resources, which machine is experiencing lags, and which programs are causing the bottlenecks. For example, AppDynamics for Databases shows how much time is spent fetching, sorting or waiting on a lock.

AppDynamics Database Monitoring polls for running queries and statistics to build a complete picture of what is happening on the database instance. This information tells you exactly what is active within the instance and most importantly what SQL statements are executing. The depth of data collected from AppDynamics Database Monitoring is comprehensive and allows detailed drill down. An expert DBA can view the resource consumption profile of an instance, drill into a performance spike, and then find the underlying root cause within seconds. When your SQL code is running well, AppDynamics Database Monitoring shows this without requiring you to analyze configuration parameters and metrics.

Events Service Dependency

Before you start the Database Agent, you must start the Controller Events Service