All Products
Search
Document Center

ApsaraDB RDS:Overview of DAS

Last Updated:Jan 11, 2024

During daily O&M of ApsaraDB RDS for PostgreSQL instances, you can use Database Autonomy Service (DAS) to handle instance failures, optimize instance performance, improve efficiency, and reduce O&M costs. DAS is a cloud service that is developed based on machine learning and expert experience. DAS provides self-awareness, self-healing, self-optimization, self-O&M, and self-securing capabilities to simplify database O&M tasks and ensure the stability, security, and efficiency of database services.

Function description

Autonomy services that are provided by DAS for ApsaraDB RDS for PostgreSQL provide the following features:

  • Autonomy center

    This feature allows you to specify a time range and view events such as exceptions, optimization events, and auto scaling events within the specified time range.

  • Session management

    This feature is used to view, export, and terminate the sessions of your RDS instance.

  • Real-time monitoring

    This feature is used to view the real-time performance of your RDS instance.

  • Storage analysis

    This feature is used to view the storage usage, such as the remaining days for which storage is available, the storage usage of individual tables, the tablespace fragments, and the storage exception diagnosis, of your RDS instance. This feature helps you identify the storage exceptions at the earliest opportunity to ensure the stability of your RDS instance.

  • Performance insight

    This feature allows you to evaluate the loads of your instance and identify the root causes of performance issues. This improves the stability of your instance.

  • Performance trend

    This feature allows you to view performance trends over specified time ranges, compare performance trends, and customize charts to view the performance trends of your RDS instance.

  • Slow SQL statement analysis

    This feature is used to check the trends, execution, and optimization suggestions for slow query logs of your RDS instance.

  • SQL Explorer and Audit

    This feature is based on the full request analysis and security audit capabilities of DAS and is integrated with the SQL statement search feature and the SQL Explorer feature. You can use the SQL Explorer and Audit feature to query information about the SQL statements that are executed on your RDS instance. Then, you can use the information to troubleshoot various performance issues.

  • Monitoring dashboard

    This feature allows you to specify RDS instances and metrics to monitor and compare the metrics of the RDS instances. You can also configure metric linkage. This helps you monitor your RDS instances.

  • Event subscription

    This feature is used to send you notifications when specified events occur. You can specify a notification method based on your business requirements.

  • Automatic SQL optimization

    This feature is used to automatically analyze and optimize your SQL queries and create indexes. This helps you quickly resolve issues related slow SQL queries and ensure the optimal performance of your RDS instance.

  • Automatic storage expansion

    This feature is used to automatically expand the storage capacity of your RDS instance and ensure the business stability when the used storage of your RDS instance is greater than or equal to the specified threshold.

References

What is DAS?