How to: Execute a Recommendation

This blog is automatically generated by AI-DBA without human revision, please note that errors may occur.

Overview

AI-DBA leverages advanced AI algorithms to analyze telemetry data and health check results from your database environment. This analysis allows AI-DBA to generate a set of recommendations aimed at improving various aspects of database management, including performance, security, administration, and maintenance.

  1. Performance Recommendations: AI-DBA examines the workload patterns and identifies potential bottlenecks or performance issues. Based on this analysis, it generates recommendations to optimize query performance, index usage, memory allocation, and resource allocation. These recommendations are designed to improve overall database performance and responsiveness.
  2. Security Recommendations: AI-DBA evaluates the security posture of your database environment. It looks for vulnerabilities, weak configurations, or potential security risks. The generated recommendations aim to enhance security by suggesting actions such as implementing access controls, enabling encryption, or patching known security vulnerabilities.
  3. Administration Recommendations: AI-DBA examines the administrative aspects of database management. It looks for areas where automation can be applied to streamline routine tasks, reduce manual effort, and improve efficiency. The recommendations may include suggestions for automating backups, maintenance tasks, or database provisioning processes.
  4. Maintenance Recommendations: AI-DBA analyzes the health check results and identifies areas that require attention in terms of database maintenance. It generates recommendations for database health optimization, data integrity checks, backup strategies, and regular maintenance routines. Following these recommendations helps ensure the reliability and availability of the database.

By analyzing telemetry data and health check results, AI-DBA gains insights into the specific challenges and areas for improvement within your database environment. The generated recommendations serve as actionable guidance to address these challenges and enhance various aspects of your database management. Implementing these recommendations can lead to improved performance, strengthened security, streamlined administration, and better overall maintenance of your databases.

Execute the Recommendation

To execute a recommendation through the AI-DBA portal, follow these steps:

  1. Navigate to the "Server" section in the AI-DBA portal.
  2. Look for the "Recommendations" tab and click on it. This will display a list of recommendations generated based on telemetry data and health check statistics.
  3. Select the specific recommendation that you want to execute by clicking on it. The recommendation description, which is generated by the AI engine, will provide detailed information about the code or action to be taken.
  4. Once you have chosen the recommendation, you will find an "Execute" button. Click on it to proceed with executing the recommendation.
  5. After clicking on the "Execute" button, you will be prompted to choose a scheduling option. AI-DBA provides three scheduling options for executing recommendations:
    a) "Apply immediately" - Select this option if you want the recommendation to be executed within 15 minutes, this allows you to abort the execution if needed.
    b) "Apply during low workload" - Choose this option if you prefer the recommendation to be executed during a period of low database workload to minimize any potential impact on performance.
    c) "Custom local time" - If you have a specific time in mind when you want the recommendation to be executed, select this option and enter the desired local time.
  6. Once you have selected the scheduling option, confirm your selection and proceed to execute the recommendation as per your chosen scheduling preference. 

By following these steps, you will be able to execute recommendations generated by AI-DBA based on telemetry data and health check statistics, with the ability to choose the desired scheduling option that best suits your requirements.

See Also

 Solution Internals
 Data Gateway