Updated on 2024-10-14 GMT+08:00

Function Overview

DBA Assistant provides you with a range of database O&M functions, making it easy to diagnose database problems, locate faults, analyze and optimize database performance. The functions include Dashboard, Sessions, Performance, Storage Analysis, Locks & Transactions, Slow Query Log, SQL Explorer, Concurrency Control, Auto Flow Control, Daily Reports, and Anomaly Snapshots.

To use DBA Assistant, contact customer service to apply for required permissions.

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. For details, see 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. For details, see Storage Analysis.

Real-Time Top SQL

The Real-Time Top SQL page displays top 5, top 10, and top 15 SQL statements by resource overhead based on real-time SQL data analysis, helping you quickly locate exception causes. For details, see Real-Time Top SQL.

Slow Query Log

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