Which two stats are available in Database Visibility? (Choose two.)

Which two stats are available in Database Visibility? (Choose two.)

A. Time Spent in Database

B. Average Number of Slow Connections

C. Top Leaked Connections

D. Top 10 Query Wait States

E. Top 10 Connections by Application

View Answer

Answer: AD

Explanation:

A. Time Spent in Database: This is a key metric typically available in database monitoring tools like AppDynamics. It measures the total time applications spend interacting with the database, which is crucial for performance tuning and identifying bottlenecks.

B. Average Number of Slow Connections: While AppDynamics tracks slow database calls, it typically does not measure the "number of slow connections" as a standalone metric. Instead, it focuses on the performance of individual queries or transactions.

C. Top Leaked Connections: Database Visibility in AppDynamics does track and identify leaked connections, which are connections that have not been properly closed. This is an important metric for database performance and health.

D. Top 10 Query Wait States: AppDynamics’ Database Visibility does provide insights into query performance, including wait states. This helps in identifying which queries are taking the most time and why, which is essential for database optimization.

E. Top 10 Connections by Application: While AppDynamics does track connections and can break down database performance by application, it typically focuses more on the performance of the queries themselves rather than ranking connections by application.

Based on this analysis, the most likely correct answers are:

A. Time Spent in Database

D. Top 10 Query Wait States