This topic describes CloudDBA in ApsaraDB RDS for SQL Server. CloudDBA is used to identify and diagnose issues on your RDS instance. CloudDBA uses AI algorithms to fix these issues and optimize your RDS instance.

Limits

CloudDBA is supported only in the following regions: China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), China (Hohhot), China (Ulanqab), China (Shenzhen), China (Heyuan), China (Chengdu), China (Hong Kong), and Singapore (Singapore).

Features

CloudDBA provides the following features:

  • View the storage information of an ApsaraDB RDS for SQL Server instance

    This feature allows you to monitor and analyze your storage at the instance level, database level, and table level. The storage monitoring and analysis data help you identify and troubleshoot storage issues. The Storage Management page in the ApsaraDB RDS console includes the following sections:

    • Storage Overview: This section provides an overview of the storage information. The storage information includes the changes in storage space over the last week, the available storage space, the used storage space, and the estimated increase in storage consumption.
    • Charts of Storage Information: This section displays the storage consumption of your RDS instance in charts. The storage consumption includes the storage usage, the percentages of used data storage space and used log storage space, and the top 5 databases that consume the most storage space.
    • Storage Trend: This section displays the storage trends of your RDS instance in a chart.
    • Top 10 Databases: This section displays the details about the top 10 databases that consume the most storage space. These details are displayed in a table.
    • Top 20 Data Tables: This section displays the details about the top 20 data tables that consume the most storage space. These details are displayed in a table.
  • Performance Optimization

    This feature provides various important performance data about your RDS instance. The Performance Optimization page in the ApsaraDB RDS console includes the following tabs:

    • Performance Insight: This tab displays the performance metrics of your RDS instance. You can use the metrics to find the sources of performance issues and improve the stability of your RDS instance.
    • Missing Indexes: This tab displays the details about the missing indexes in charts and tables. This tab also displays the SQL statements that are used to create these indexes.
    • Index Usage: This tab displays the details about the created indexes in charts and tables. This tab also displays the SQL statements that are used to create these indexes.
    • Statistics: This tab displays the performance statistics of your RDS instance in charts and tables.
    • TOP SQL: This tab displays the details about the SQL statements that are executed on your RDS instance. The SQL statements are sorted based on different metrics, and the SQL statement statistics are displayed in charts and tables. You can query real-time SQL statement statistics.
    • TOP Objects: This tab displays the real-time performance drains that are caused by various objects, such as stored procedures, functions, and triggers. You can identify the top N objects that cause the highest performance drain and the SQL statements in these objects.
  • Lock optimization
    This feature provides various important performance data about your RDS instance. The Lock Optimization page in the ApsaraDB RDS console includes the following tabs:
    • DeadLock: This tab displays the details about the deadlocks that are detected in your RDS instance. The details are displayed in charts and tables.
    • Blocking: This tab displays the details about the blocking problems that are detected in your RDS instance. The details are displayed in charts and tables.
  • Slow SQL: This tab displays and analyzes the SQL statements with high CPU utilization. This tab also displays the slow SQL query statistics and the slow SQL query details.