View Database Activity in Database Visibility
Once you have configured a database Collector in AppDynamics Monitoring, you can access Database Visibility either from the AppDynamics Home page or you can link to the Database Visibility database instance Dashboard by right-clicking the database and selecting View in Database Visibility on the Application Flow Map, Tier Flow Map or Node Flow Map.
Database backends with the same hostname, port number, and database type as a database server already configured in a database Collector are automatically matched with the Collector, and drill downs from the Application Flow Map, Tier Flow Map or Node Flow Map to Database Visibility are enabled.
View Business Transaction Snapshot Correlated Database Details
Available for Java or PHP applications and their relational database backends, snapshot correlation shows the details of queries executed by the business transaction. It also shows the clients, sessions, and schemas in which those queries were executed.
View Database Details
- On the Business Transactions page, double click on any business transaction to view the queries that are executed in that transaction.
- Click the DB Queries tab. On this tab, you can view the queries that were issued by this business transaction.
View Correlated Database Details
- From a list of business transactions with snapshots, choose a longer running business transaction that accesses the database, one that takes a few seconds or more. These are more likely to have captured database details.
- Double-click Drill Down above the database icon. The correlated database details window appears.
- Click the Queries, Clients, Sessions, and Schema tabs to view details of database activity that occurred around the time when the snapshot was captured. For relational databases, these details reflect the database activity from the transaction snapshot. For non-relational databases, these details reflect the database activity that occurred around the time of the transaction snapshot.
For Oracle backends only: If you want to list only the queries executed by the Transaction Snapshot in the Transaction Snapshot window, you can enable the jdbc-dbcam-integration-enabled node property for the Java Agent.