Help Center/ Relational Database Service_RDS for SQL Server/ User Guide/ Problem Diagnosis and SQL Analysis/ Function Overview
Updated on 2025-12-12 GMT+08:00
View PDF
Share

Function Overview

DBA Assistant provides visualized database O&M and intelligent diagnosis for developers and database administrators (DBAs), making database O&M easy and efficient. By analyzing resource and storage usages, it helps you quickly locate faults and keep track of instance status.

To use DBA Assistant on the RDS console, IAM users must have the RDS FullAccess, DAS FullAccess (or DAS Administrator), and CES FullAccess permissions. To grant these permissions, see Using IAM Roles or Policies to Grant Access to RDS.

Scenarios

  • Setting a slow session threshold can help you quickly identify abnormal sessions and kill the sessions when an exception occurs in your instance, so that your instance can recover quickly and ensure database availability.
  • If your instance storage is full, you can learn about the storage usage and disk space distribution on the Storage Analysis page. You can enable storage autoscaling. When the available storage of your instance drops to the threshold, autoscaling is triggered. For details, see Configuring Autoscaling.

Functions

Table 1 lists the functions supported by DBA Assistant.

Table 1 Function description

Function

Description

Reference

Sessions

The Sessions page displays slow sessions, active sessions, and total sessions. You can quickly filter slow sessions or active sessions by user, host IP address, or database name. Kill Session can be used for urgent instance recovery to ensure database availability.

Managing Real-Time Sessions

Storage Analysis

Storage occupied by data and logs and historical changes of storage usage are important for database performance. The Storage Analysis page displays storage overview and disk space distribution of your instance. In addition, DBA Assistant can estimate the available days of your storage based on historical data and intelligent algorithms, so that you can scale up storage in a timely manner. Overview, Abnormal Tables, Top 20 Databases, and Top 20 Tables are also available on this page.

Managing Storage Capacity

Deadlocks

The Deadlocks page provides lock statistics and displays information such as the transaction start time, session ID, locked resource details, and deadlock mode, helping you locate and optimize problematic SQL statements and other exceptions.

Viewing Deadlock Statistics

Indexes

The Indexes page displays missing indexes, missing indexes in user seeks, and index usage of your DB instance to help you troubleshoot performance problems.

Viewing Index Statistics

Slow Query Logs

The Slow Query Logs page displays slow queries within a specified time period. You can view top slow query logs by user or client IP address, sort statistics, and identify sources of slow SQL statements.

Viewing Slow Query Logs of a DB Instance

All Query Logs

After Collect All Query Logs is enabled, you can filter, search for, and analyze SQL statements in multiple dimensions and gain a comprehensive insight into all SQL statements. Top SQL helps you locate exceptions.
Parent Topic: Problem Diagnosis and SQL Analysis