The SQL Explorer and Audit feature incorporates the SQL statement search and SQL Explorer features based on the full request analysis and security audit capabilities of Database Autonomy Service (DAS). You can query information about executed SQL statements and use the information to troubleshoot performance issues and identify risk sources. In addition, you can use the traffic playback and stress testing feature to check whether you need to scale up your database instance to handle workloads during peak hours.

Prerequisites

  • The database instance that you want to manage is connected to DAS and is in the Accessed state.
  • DAS Professional Edition is enabled for the database instance. For more information, see Purchase DAS Professional Edition.
  • The SQL Explorer and Audit feature is available only for the following types of databases:
    • ApsaraDB RDS for MySQL High-availability Edition and Enterprise Edition
    • ApsaraDB RDS for SQL Server High-availability Edition and Cluster Edition
    • ApsaraDB RDS for PostgreSQL High-availability Edition
    • PolarDB for MySQL Single Node Edition, Archive Database Edition, and Cluster Edition
    • PolarDB-X 2.0
  • The SQL Explorer and Audit feature is available in different regions for different types of databases.
    Database type Region
    • ApsaraDB RDS for MySQL High-availability Edition and Enterprise Edition
    • ApsaraDB RDS for SQL Server High-availability Edition and Cluster Edition
    • PolarDB for MySQL Single Node Edition, Archive Database Edition, and Cluster Edition
    China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Shenzhen), China (Zhangjiakou), China (Hohhot), China (Chengdu), China (Guangzhou), China (Heyuan), China (Ulanqab), China (Hong Kong), Singapore (Singapore), Malaysia (Kuala Lumpur), and Indonesia (Jakarta)
    ApsaraDB RDS for PostgreSQL High-availability Edition China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Zhangjiakou), Singapore (Singapore), Malaysia (Kuala Lumpur), and Indonesia (Jakarta)
    PolarDB-X 2.0 China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), and Singapore (Singapore)

Pricing

For information about the pricing of DAS Professional Edition, see Pricing of DAS Professional Edition.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. On the page that appears, click the ID of the database instance that you want to manage. The instance details page appears.
  4. In the left-side navigation pane, choose Request Analysis > SQL Explorer and Audit. You can use the following three features
    • Search: This feature is used to query and export SQL statements and related information such as the databases on which the SQL statements are executed, status of the SQL requests, and the execution duration of each SQL statement. For more information, see Search.
    • SQL Explorer: This feature is used to diagnose the health status of SQL statements, troubleshoot performance issues, and analyze business traffic. For more information, see SQL Explorer.