Database Monitoring

How does database monitoring work?

AppDynamics continuously monitors test or production database instances 24/7 and stores detailed historical data about the resource consumption and wait events in a repository. This data is correlated, aggregated and sorted so that it can be easily displayed in the intuitive web-based user interface.
 

Key benefits of database monitoring tools

• Visualize end-to-end application performance, from the browser to the database

• Get alerts when database thresholds are violated

• Monitor and improve database performance metrics like top users, programs, SQL, objects and more.

• See execution plans for slow SQL to isolate performance bottlenecks
   

Troubleshoot performance issues in a production environment

AppDynamics' fine-grained historical data offers applications teams the ability to retroactively troubleshoot and diagnose the root cause of database-related performance issues – in a live production environment.
 

Trend database performance over time

With AppDynamics' database monitoring, you can monitor and trend key performance metrics such as resource consumption, database objects, schema statistics and more, allowing you to proactively tune and fix issues before they affect end users.
 

Continuously monitor in a high-volume production environment

With less than 1% overhead, AppDynamics for Databases is suited for monitoring high-volume production applications 24/7, giving application teams complete visibility into database performance around the clock.
 

Easy to install and use

AppDynamics for Databases installs in a matter of minutes, and its intuitive web interface makes it easy for anyone to find and diagnose performance issues.

Monitor everything in a single pane-of-glass

AppDynamics supports DB2, Oracle, Postgres, MySQL, and SQL Server, all from one central installation of AppDynamics. There's no need for separate database monitoring products for different databases – with AppDynamics you see it all in a single pane-of-glass.

More About Database Monitoring with AppDynamics
 

Problems solved with database monitoring

• Slow database response time

• Database load issues

• Unpredictable performance spikes

• Locking problems

• Internal database contention
   

Database monitoring provides visibility into:

• SQL & Stored Procedures

• Execution plans

• Wait states

• Resource consumption

• Database objects

• Schema statistics

• User sessions

• Data files

• Change events