The Database tier in the Application View provides a visual indication about the database performance and availability compared to the set Minor . 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.
To see the Application View tab, your system must include BMC TrueSight App Visibility Manager and you must have -level access, or higher.
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:
The following example describes the information in the Database tier:
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.
Click one or more database names to examine problem details.
For selected databases, the following details are displayed on the Summary tab, below the Tier Members section. Click a column heading to sort entries by that category.
Click to select View Business Transactions to see the transactions that queried the selected database
|Severity icon||Representation of the severity level of events on the database|
Depending on the type of database, the name is displayed using the following syntax:
|Number of database queries and operations sent to the database per second|
Variations in the reported metrics might occur between the values in the tier box and the total of tier members because of the way partial (fractional) results are calculated.
Percentage of database operations with latency violations or errors that exceed defined thresholds
Percentage of database operations with latency violations
Percentage of database operations server with errors
To examine transaction details for a selected database, from the Summary tab, select View Business Transactions from the row action menu of a specific database.
Click the Problems tab to examine the types of problems on the selected databases.
For selected databases, the following details are displayed. Click a column heading to sort entries.
|Severity icon||Representation of the event severity level|
Brief description, such as
Name of the database
The severity level remains unchanged until all problems with operations of that level are closed.
Time and date that the problem started which caused the displayed severity
If the problem started earlier than the displayed time, click the start time to reset the time selection. The time slider moves to the five-minute period that includes the problem start time.
Value of the threshold that was crossed
For a list of default threshold values, see Application metrics and problems.
Open or Closed, which represents the current status of the problem, and time in which the problem was resolved, if applicable
Analyze the slowest database queries on the selected databases. A database can show no problems, or no latency violations, yet you can still examine the slowest queries.
The Top 10 Slowest Queries lists the ten slowest queries for the selected database member or members, for the selected five-minute period. No matter how many databases are selected, only ten queries are listed, sorted according the the maximum latency by default. The slow-queries list provides the following information for each query:
Troubleshooting: Same database instance appears twice in Application View