Database Visibility

Use AppDynamics Database Visibility to optimize application performance and ensure your databases aren’t the cause of poor application performance. From a single pane of glass, you can monitor all your databases. From AppDynamics application flow maps, you can quickly drill down to the Database Dashboard and troubleshoot database issues.
Overview
AppDynamics Database Visibility delivers agentless, heterogeneous, database monitoring capabilities for the applications that access the database. AppDynamics provides deep visibility that can help you not only quickly identify and resolve any database performance bottlenecks, but also understand the impact of these problems on application performance and end-user experience.

AppDynamics continuously monitors test or production database instances 24x7 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 of AppDynamics.

The historical data in the AppDynamics repository allows you to answer questions such as: “What caused the slowdown in the application yesterday after lunch?” and “Why is the overnight batch job still running at 9 am this morning?” You can also use the historical data in a proactive manner; for example, to assess upward trends in SQL response time or resource consumption, or to tune and fix issues before they become end-user problems.

This video presents a walk through of the Database Visibility interface, the windows available and the metrics presented. The windows, reports, and metrics available are database dependent.
Video Thumbnail
AppDynamics Database Visibility does not require you to install software agents on your monitored database servers; instead, you install the AppDynamics Database Agent on a remote, central server to monitor all your database servers. This makes it easier to for you to deploy the Database Agent and adds no monitoring overhead to your database servers. AppDynamics is ideally suited to cloud, and virtual or physical architectures, with outstanding performance in high-load, production environments.

Supported databases:

  • Oracle 10g, 11g, and 12c

  • SQL Server 2005 – 2014

  • SAP/Sybase ASE 15.0-16.X

  • MySQL 4+ (including MariaDB and Percona)

  • SAP/Sybase IQ

  • MongoDB 2.X+

  • IBM DB2 LUW 9.5+

  • PostgreSQL 8+

  • Microsoft Azure SQL

Supported monitored operating systems:

  • Windows

  • Linux

  • Solaris

  • AIX

Finding the root cause is the most time consuming part of solving an application or database performance issue. Database visibility can help you answer questions such as: “What caused the slowdown in the application yesterday after lunch?” or “Why is the overnight batch job still running at 9 am this morning?”

Database Visibility provides insight into popular database performance issues, such as:

  • Bad query performance

  • Bad and missing indexes

  • User and query conflicts

  • Capacity issues

  • Inefficient configuration parameters

You can also use this historical data in a proactive manner to diagnose problems such as:

  • Slow database response times

  • Database load issues

  • Unpredictable performance spikes

  • Locking problems

  • Internal database contention

AppDynamics Database Visibility can monitor any combination of supported database platforms from a single central installation, which means that database performance management can be standardized using a best-of-breed performance monitoring methodology. Software is inclusive of the Database, so why only monitor software and not the DB? With a unified view, you can:

  • Correlate bad performance calls from the application to the offending database.

  • Context and actionable information, not just DB metrics.

  • End-to-End Visibility, all in the context of a business transaction
Here we see a transaction snapshot for a slow business transaction caused by poor query performance. The most obvious place to look for poor query performance is in the query itself. Problems can result from queries that take too long to identify the required data or bring the data back. Look for these issues in queries:
  • Selecting more data than needed

  • Inefficient joins between tables

  • Too few or too many indexes

  • Too much literal SQL causing parse contention
Try AppDynamics

Introduction

AppDynamics Database Visibility delivers agentless, heterogeneous, database monitoring capabilities for the applications that access the database. AppDynamics provides deep visibility that can help you not only quickly identify and resolve any database performance bottlenecks, but also understand the impact of these problems on application performance and end-user experience.

How does AppDynamics Database Visibility work

Video Thumbnail

AppDynamics continuously monitors test or production database instances 24x7 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 of AppDynamics.

The historical data in the AppDynamics repository allows you to answer questions such as: “What caused the slowdown in the application yesterday after lunch?” and “Why is the overnight batch job still running at 9 am this morning?” You can also use the historical data in a proactive manner; for example, to assess upward trends in SQL response time or resource consumption, or to tune and fix issues before they become end-user problems.

This video presents a walk through of the Database Visibility interface, the windows available and the metrics presented. The windows, reports, and metrics available are database dependent.

Database Agent technology and supported platforms

AppDynamics Database Visibility does not require you to install software agents on your monitored database servers; instead, you install the AppDynamics Database Agent on a remote, central server to monitor all your database servers. This makes it easier to for you to deploy the Database Agent and adds no monitoring overhead to your database servers. AppDynamics is ideally suited to cloud, and virtual or physical architectures, with outstanding performance in high-load, production environments.

Supported databases:

  • Oracle 10g, 11g, and 12c

  • SQL Server 2005 – 2014

  • SAP/Sybase ASE 15.0-16.X

  • MySQL 4+ (including MariaDB and Percona)

  • SAP/Sybase IQ

  • MongoDB 2.X+

  • IBM DB2 LUW 9.5+

  • PostgreSQL 8+

  • Microsoft Azure SQL

Supported monitored operating systems:

  • Windows

  • Linux

  • Solaris

  • AIX

What kinds of problems can Database Visibility uncover

Finding the root cause is the most time consuming part of solving an application or database performance issue. Database visibility can help you answer questions such as: “What caused the slowdown in the application yesterday after lunch?” or “Why is the overnight batch job still running at 9 am this morning?”

Database Visibility provides insight into popular database performance issues, such as:

  • Bad query performance

  • Bad and missing indexes

  • User and query conflicts

  • Capacity issues

  • Inefficient configuration parameters

You can also use this historical data in a proactive manner to diagnose problems such as:

  • Slow database response times

  • Database load issues

  • Unpredictable performance spikes

  • Locking problems

  • Internal database contention

How Database Visibility integrates with AppDynamics Application Performance Monitoring

AppDynamics Database Visibility can monitor any combination of supported database platforms from a single central installation, which means that database performance management can be standardized using a best-of-breed performance monitoring methodology. Software is inclusive of the Database, so why only monitor software and not the DB? With a unified view, you can:

  • Correlate bad performance calls from the application to the offending database.

  • Context and actionable information, not just DB metrics.

  • End-to-End Visibility, all in the context of a business transaction
Here we see a transaction snapshot for a slow business transaction caused by poor query performance. The most obvious place to look for poor query performance is in the query itself. Problems can result from queries that take too long to identify the required data or bring the data back. Look for these issues in queries:
  • Selecting more data than needed

  • Inefficient joins between tables

  • Too few or too many indexes

  • Too much literal SQL causing parse contention

What's Next

Try AppDynamics
Getting Started
  1. Install an AppDynamics Database Visibility Agent on your system.

  2. Configure the Database Collectors.

  3. Optional. Associate the Database Collector with an AppDynamics monitored application. 

  4.  Observe key performance indicators of all databases and servers on the Databases window.

  5. Double-click a Database Collector to view fine, database-performance details and start to troubleshoot your database performance from the Database Dashboard.
Video Thumbnail
Advanced Training
We provide instructor-led training, interactive self-paced courses, learning bytes courses, and private training.
AppDynamics University