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: BC

Explanation:

Database Visibility provides metrics on the performance of your database and helps troubleshoot performance-related issues. Database Visibility consists of four main components: Database Agent, Collector, Controller, and Events Service (on-premises only). The Database Agent is a standalone Java program that collects performance metrics about your database instances and database servers. The Collector is the process that runs within the Database Agent to collect performance metrics about your database instances and database servers. The Controller is the central interface where you can see all your database instances and database server performance metrics. The Events Service stores high volumes of metric data.

According to the Overview of Database Visibility, the following types of information are sent to the Controller:

Database-level metrics, such as the number of queries processed and other database statistics Names and attributes of all sessions, clients, queries, and other objects on the monitored system

The following types of information are sent to the Events Service:

Time that each query spends at each wait state

Individual query statistics for databases that support it

Information about individual execution plans in databases that support it

Therefore, B (Average Number of Slow Connections) and C (Top Leaked Connections) are two stats that are available in Database Visibility.

Reference: Cisco AppDynamics Associate Administrator Certification Overview of Database Visibility – AppDynamics Database Visibility – AppDynamics