After you enable the DAS audit log, you can use the SQL Explorer and Audit feature. The SQL Explorer and Audit features, data storage modes, and billing methods vary depending on the version of the audit log that you enable. This topic describes the differences in SQL Explorer and Audit features for different DAS audit log versions and addresses common questions about data migration between them.
What are the differences between the SQL Explorer and Audit features in different versions of DAS Enterprise Edition?
On the Version Management page of the DAS console, you can determine the DAS Enterprise Edition version of a database instance from the tab under which it is listed.
The SQL Explorer and Audit feature, data storage mode, and billing rules differ for each version of DAS Enterprise Edition.
|
Item |
DAS Enterprise Edition V3 |
DAS Enterprise Edition V2 |
DAS Enterprise Edition V1 |
DAS Enterprise Edition V0 |
|
Billable items |
This version uses the pay-as-you-go billing method. The billable items are:
Enterprise Edition V3 uses a hybrid storage model for hot and cold data and provides more granular, feature-based billable items. This approach offers more flexible billing and significantly reduces costs. For more information, see Billing details. |
This version uses the pay-as-you-go billing method. The billable items are:
Compared to Enterprise Edition V1, Enterprise Edition V2 uses a different underlying storage architecture. It employs a hybrid storage model for hot and cold data to improve performance at a lower cost. For more information, see Billing details. |
The fees consist of a subscription fee and a storage fee for SQL Explorer and Audit. Data from SQL Explorer and Audit is stored in hot storage. A relatively high storage fee is charged on a pay-as-you-go basis. For more information, see Billing details. |
This version uses the pay-as-you-go billing method. You are charged for the data storage of SQL Explorer and Audit. Data from SQL Explorer and Audit is stored in hot storage, and a relatively high storage fee is charged. For more information, see Billing details. |
|
Search, SQL Explorer, and security audit |
DAS creates a task that you can track if one of the following conditions is met:
|
DAS directly queries, exports, and analyzes stored data without creating an asynchronous task. |
||
|
Task list |
This is a new feature. You can view the tasks and their details created by features such as search, export, SQL Explorer, and security audit. |
This feature is not available. |
||
|
OpenAPI |
You can call the GetDasSQLLogHotData operation to query the details of hot data from SQL Explorer and Audit for a database instance. |
You can call the DescribeSQLLogRecords operation to query the log details from SQL Explorer and Audit for a database instance. Note
After you migrate to Enterprise Edition V3, the DescribeSQLLogRecords operation is no longer supported. You can call only the GetDasSQLLogHotData operation. |
||
How to view the storage space used by audit log data?
Log on to the DAS console.
In the left-side navigation pane, click Intelligent O&M Center > Instance Monitoring.
On the Instance Monitoring page, click the name of the target instance.
In the left-side navigation pane, click SQL Explorer and Audit.
View the storage usage displayed next to the Service Settings button.