Analyzing database problems with the Database tier

The Database tier in the Application View provides a visual indication about the database performance and availability compared to the set Minor and Critical thresholds. Information about databases is obtained from the App Visibility agents through the database queries and responses that the application server sends and receives.

This topic describes how to use the Database tier to identify performance and availability problems in your application databases.

Before you begin

To see the Application View tab, your system must include BMC TrueSight App Visibility Manager and you must have Application Operator-level access, or higher.

Determine if the application has problems in the Database tier

In the Application View, the Database tier displays the number of databases that have one or more problems (latency violations or errors) with queries or database operations during the selected period. The tier displays the number of database instances that impact one or more transactions, causing latency violations or errors:

Impacted Databases (number inside the circle). Number of impacted database instances
Colored part of the circle. Ratio of impacted database instances to total database instances. The color reflects whether the percentage of databases experiencing issues exceeds the defined thresholds.
Operations per second. Number of database queries and operations per second

The following example describes the information in the Database tier:

Example of the Database tier

For the five-minute period reflected in the example, the Database tier shows that the combined number of operations per second for all the databases in the tier is three operations per second. The number of impacted databases, that is, the number of databases with latency violations or errors on queries or database operations, is two. You can see that the number of impacted databases is approximately a quarter of all the servers in the tier.

To analyze database problems with the Database tier

On the Application View tab of the Application Monitoring page, position the time slider to select a five-minute period of interest.
Click the Database tier to display the databases that were active in the time period.

Example of the Tier Members and Selection Details
In the Tier Members section of the page, click a filter to show or hide databases with the selected severity.
Filters for databases with Critical and Minor events are selected by default to show the servers with detected issues.

Evaluating details of selected databases

Click one or more database names to examine problem details.

Unknown macro: confluence_toc-zone. Click on this message for details.

Where to go from here

Analyzing-business-transactions