Updated on 2024-03-01 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.

DBA Assistant consists of the following modules:

Dashboard

Dashboard shows the status of your instance, including alarms, resource usages, and key performance metrics. DBA Assistant diagnoses instance health using operational data analytics and intelligent algorithms, and provides you with solutions and suggestions for handling detected exceptions. For details, see Dashboard.

Sessions

On the Sessions page, you can view current session statistics of your instance, identify abnormal sessions, and kill the sessions. For details, see Sessions.

Performance

The Performance page displays key metrics of your instance and provides metric comparison between different days. You can keep track of metric changes and detect exceptions in a timely manner. Monitoring by Seconds helps accurately locate faults. For details, see Performance.

Slow Query Log

The Slow Query Log page displays slow queries within a specified time period. Slow query logs are collected by user, IP address, SQL template, and other keywords, sort statistics, and identify sources of slow SQL statements. For details, see Slow SQL Analysis.

SQL Explorer

After Collect All SQL Statements is enabled, you can gain a comprehensive insight into SQL statements on the SQL Explorer page. For details, see SQL Insights and Concurrency Control.