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 . 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 TrueSight App Visibility Manager and you must have -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:
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.
Examine a summary of database issues
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 .
Examine specific problems with databases
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
Examine the slowest database queries
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:
- Query name
- Number of slow requests, that is, the number of requests that exceeded a performance threshold
- Total number of requests
- Average latency, in milliseconds
- Maximum latency, in milliseconds
- Minimum latency, in milliseconds
- Database name
Where to go from here
Troubleshooting: Same database instance appears twice in Application View