Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

Database Monitoring FAQ

Table of Contents

 

Why are no queries found in the 'DB Queries' tab under the BT Dashboard?

Check to see if all these requirements are met:

  • Do you have a license to monitor databases? See Database Visibility for details.
  • Does the business transaction contain at least one relational database backend, that can be monitored with AppDynamics Database Visibility? See the list of supported database environments in Database Visibility Supported Environments.
  • Is at least one backend in the business transaction linked to a monitored database collector? You can find information on how to link a backend with a database collector in Monitor Databases.
  • Is at least one of the nodes making calls to the relational database backend Java, PHP, or .NET?
  • For correlating queries executed by PHP or .NET, the controller version needs to be 4.5.4+. However, for Java, the controller version needs to be 4.5+.
  • Is the database agent monitoring the database collector (linked to the backend in the business transaction) version 4.5+?
  • Do you have permissions to view at least the database collectors linked to the backends in the business transaction?

 

Further troubleshooting the DB Queries tab

Are you still unable to see queries under the ‘DB Queries’ tab after confirming the above requirements? Check these possible reasons:

Issue

Cause/Scenario

Query texts aren’t sampled by the (Java, PHP, or .NET) app agent

Fast-running queries

Query texts aren’t sampled by the DB agent

Fast-running queries

The query text given by the database doesn’t match the query text executed by the (Java, PHP, or .NET) app agent

Special cases, like stored procedure calls

 

In what order are queries in the ‘Transaction Snapshot Viewer’ fetched? 

The order in which queries in the ‘Transaction Snapshot Viewer’ are fetched depends on the type of database—Oracle, or other.

 

What is the order of Transaction Snapshot Viewer queries with Oracle databases?

In Oracle databases with both 'Oracle-specific correlation' and 'Generic Snapshot Correlation' enabled, you may see the following, consecutively:

 

  1. Oracle specific snapshot correlation (Pre-4.5 Java → Oracle correlation) - No bottom message in the UI.

    If fetching by this method (#1) returns an empty list, then the next fallback is:

  2. Generic snapshot correlation - Bottom message: "For security reasons, app agents capture only the query groups. Therefore, some of the queries listed are not executed by this snapshot."

    If fetching by this method (#2) returns an empty list, then the next/final fallback is:

  3. Time-based correlation - Bottom message: "Database agent couldn't capture any data related to this snapshot. You are now seeing data captured a minute before and after the snapshot was captured."

 

 

What is the order of Transaction Snapshot Viewer queries with non-Oracle databases?

For other relational database types, including Oracle databases with the Oracle-specific correlation disabled, you may see:

 

  1. Generic snapshot correlation - Bottom message: "For security reasons, app agents capture only the query groups. Therefore, some of the queries listed are not executed by this snapshot."

    If fetching by method #1 (above) returns an empty list, then the fallback is:

  2. Time-based correlation - Bottom message: "Database agent couldn't capture any data related to this snapshot. You are now seeing data captured a minute before and after the snapshot was captured."
Version history
Revision #:
3 of 3
Last update:
‎03-02-2020 10:06 AM
Updated by:
 
Labels (1)


Found this article helpful? Click the Thumbs Up button.
Have an additional comment? Post it below.
0 Kudos