Versions Compared

    Key

    • This line was added.
    • This line was removed.
    • Formatting was changed.
    Comment: Published by Scroll Versions from this space and version 20.6
    Sv translation
    languageen
    Appd tocbox

    Related pages:


    To view the application dashboard of a specific application, click the application on the Home page. On the application dashboard, you can view the following:

    • Unconnected Backends: If there are any unconnected backend database servers, a message is displayed the flowmap displays the unconnected database server icon. You can click the icon, then click Connect to connect the backend database to the appropriate server or cluster in Database Visibility.
    • Status of the Database: There are different icons to display different states of the database based on the health rule violation. For information about the different icons, see Database Icons.
    • Quick View of Database Visibility: If you require to view some of the main metrics without going to the Database Visibility UI, you can click the database icon and the quick view of the metrics is displayed. For detailed information, click View in Database Visibility.

    Image RemovedImage Added

    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.

    Image Modified


    Tip
    The AppDynamics Database Visibility section in the Application Database Dashboard displays which database Collector is associated with the database. If you require to change this association, right-click the database and then click Edit Connection to Database Visibility and choose the appropriate server or cluster that is configured in Database Visibility.


    View Business Transaction Snapshot Correlated Database Details

    Available for Java, .NET, and 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 

    1. On the Business Transactions page, double click on any business transaction to view the queries that are executed in that transaction.
    2. Click the DB Queries tab. On this tab, you can view the queries that were issued by this business transaction.

    View Correlated Database Details 

    1. From a list of business transactions with snapshots, choose a longer long-running business transaction that accesses the database, one that takes a few seconds or more. These are more likely to have captured database details.
    2. Double-click Drill Down above the database icon. The correlated database details window appears.
    3. Click the QueriesClientsSessions, 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.

    Info

     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.

    ...