Capacity planning is the process of estimating and allocating the resources needed to meet the current and future demands of an application. For a regionally partitioned application, where different users and organizations are assigned to different databases based on their location, capacity planning requires that the administrator monitors the number of users and orgs mapped to each database and ensures that they do not exceed the available resources.
According to the AppDynamics Analytics - AppDynamics, one way to meet this requirement is to schedule an analytics query to check and report on the result periodically. An analytics query is a SQL-like query that allows you to analyze and visualize the data collected by AppDynamics, such as business transactions, logs, metrics, events, and custom data. You can use analytics queries to create dashboards, widgets, reports, and alerts that provide insights into the performance and behavior of your applications and their components.
To schedule an analytics query to check and report on the number of users and orgs mapped to a database, the administrator can follow these steps:
Go to Analytics > Search.
Select the data source that contains the user and org information, such as Business Transactions, Logs, or Custom Data.
Enter the query that counts the number of users and orgs for each database, such as SELECT database, COUNT(DISTINCT user), COUNT(DISTINCT org) FROM data_source GROUP BY database.
Click the Save button and enter a name and description for the query.
Click the Schedule button and select the frequency, time range, and recipients for the query execution and report delivery.
Click Save.
Therefore, A (Schedule an analytics query to check and report on the result periodically) is the correct answer. References:
AppDynamics Analytics - AppDynamics
Cisco AppDynamics Associate Administrator Certification
Analytics Queries - AppDynamics
