If you want to use the SQL Explorer and Audit feature to record and analyze the execution of SQL statements, you must enable Database Autonomy Service (DAS) Enterprise Edition, which is formerly known as DAS Professional Edition. DAS Enterprise Edition has multiple versions that vary in the billing method. This topic describes the supported databases and regions, billing, benefits, and usage notes of each version of DAS Enterprise Edition.
Versions of DAS Enterprise Edition
DAS Enterprise Edition (formerly known as DAS Professional Edition): You are charged for using this edition. DAS Enterprise Edition provides the SQL Explorer and Audit feature based on the features of DAS Cost-efficient Edition. DAS Enterprise Edition has the following versions that vary in the billing method:
DAS Enterprise Edition V0 (formerly known as DAS Professional Edition of the previous version that uses the old engine): You are charged for data storage of SQL Explorer and Audit on a pay-as-you-go basis.
DAS Enterprise Edition V1 (formerly known as DAS Professional Edition of the previous version): You are charged for the subscription and the data storage of SQL Explorer and Audit.
DAS Enterprise Edition V2 (formerly known as DAS Professional Edition of the new version): DAS Enterprise Edition V2 is billed on a pay-as-you-go basis. Compared with DAS Enterprise Edition V1, DAS Enterprise Edition V2 changes the underlying storage architecture. The hybrid storage of hot and cold data improves service performance at lower costs.
DAS Enterprise Edition V3: DAS Enterprise Edition V3 is billed based on the pay-as-you-go billing method and supports hybrid storage of hot and cold data. The billable items are subdivided based on features. This allows flexible billing and greatly reduces costs.
If you want to enable DAS Enterprise Edition for a database instance, you can enable only DAS Enterprise Edition of the latest version that is supported by the database instance. The latest version provides a more flexible billing method that reduces your costs. We recommend that you use DAS Enterprise Edition of the latest version.
You can migrate data from DAS Enterprise Edition V1 or DAS Enterprise Edition V2 to DAS Enterprise Edition V3 free of charge. Before the migration is complete, you are charged based on the billing rules of the original version. After the migration is complete, you are charged based on the billing rules of the new version. For more information, see the How do I migrate data between different versions of DAS Enterprise Edition? section of the "FAQ" topic.
In the DAS console, you can view the version of DAS Enterprise Edition that is enabled for your database instance in the upper-right corner of the details page of the database instance or on the Version Management page.
Supported databases and regions
For more information, see Editions and supported features.
Billing
For more information, see Billing details.
Benefits
After you enable DAS Enterprise Edition, you can use the following features:
The SQL Explorer and Audit feature provided by DAS Enterprise Edition records the information about all executed data query language (DQL), DML, and DDL statements. DAS obtains the information from database kernels, which consumes only a small amount of CPU resources.
Search: allows you to query SQL statements by specifying search conditions and export the information about SQL statements.
Security audit: helps you identify high-risk SQL statements, SQL injection attacks, abnormal SQL statements, and new request sources to ensure data security.
SQL Explorer: allows you to identify faults, query SQL templates and traffic data of databases, and check the health status of SQL statements.
Pre-compute, analyze, aggregate, and store SQL statements at the minute level for fast responses.
Troubleshoot errors caused by faulty SQL statements.
Export SQL templates and traffic data of databases.
Traffic playback and stress testing: allows you to evaluate the database capacity, play back traffic for stress testing, and perform stress testing based on the previous business scenarios and traffic data.
Automatic SQL optimization: automatically diagnoses slow SQL queries, generates index optimization suggestions, and creates indexes without table locks.
Usage notes
After you enable DAS Enterprise Edition, the following issues may occur due to the limits of DAS Enterprise Edition:
DAS Enterprise Edition does not support self-managed databases.
For more information about the Alibaba Cloud databases and regions that are supported by DAS Enterprise Edition, see Editions and supported features.
The storage space used by a database instance for which DAS Enterprise Edition is enabled is provided by DAS and does not consume the storage space of the database instance.
The search, security audit, or SQL Explorer feature takes effect only on data that is generated after DAS Enterprise Edition is enabled and is within the specified storage duration.
If you disable DAS Enterprise Edition for a database instance, the SQL Explorer and Audit feature is disabled and all data related to DAS Enterprise Edition is deleted, including the data generated by the SQL Explorer feature and analytical data. However, your business is not affected. We recommend that you export and save the data to your computer before you disable DAS Enterprise Edition for the database instance. For more information about how to export data, see the Disable SQL Explorer and Audit section of the "Overview" topic.
When you enable DAS Enterprise Edition V1 for a data instance, make sure that the quota of instances for which DAS Enterprise Edition V1 can be enabled is sufficient within your Alibaba Cloud account. For more information about how to increase the quota of available instances for DAS Enterprise Edition V1, see Enable and manage DAS Enterprise Edition.
After you enable or disable DAS Enterprise Edition for a database instance, you need to wait about 3 minutes before DAS Enterprise Edition is disabled or enabled for the database instance.
FAQ
Q: How do I view the storage space used by the SQL Explorer and Audit data of a database instance for which DAS Enterprise Edition is enabled?
A: You can view the storage space used by the SQL Explorer and Audit data of a database instance on one of the following pages:
View the used storage space on the Version Management page:
Log on to the DAS console.
In the left-side navigation pane, click Version Management.
On the Version Management page, view the used storage space of the database instance.
View the used storage space on the SQL Explorer and Audit page:
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.Instance Monitoring
On the Instance Monitoring page, find the database instance that you want to view and click the instance ID. The instance details page appears.
In the left-side navigation pane, choose Request Analysis > SQL Explorer and Audit.
View the storage space used by the data of SQL Explorer and Audit next to Service Settings.
You can use the search feature to query and export the historical data of SQL Explorer and Audit.