Help Center/ TaurusDB/ User Guide/ DBA Assistant/ Problem Diagnosis/ Managing Daily Reports
Updated on 2026-05-22 GMT+08:00
View PDF
Share

Managing Daily Reports

Scenarios

To keep TaurusDB instances running efficiently, regular health checks are essential. Manual checks can be time-consuming and may miss critical issues, risking workload stability. To solve these problems, TaurusDB allows you to start instance diagnosis and subscribe to diagnosis reports. The Daily Reports page summarizes the instance status of the previous day, covering performance and storage analysis, SQL analysis, and database/table analysis. You are advised to perform instance diagnosis every day to ensure smooth operations.

  • Starting a Diagnosis: You can perform a comprehensive health check on the current instance.
  • Viewing Diagnosis Reports: You can view the current and historical diagnosis reports.
  • Subscribing to Diagnosis Reports: Simple Message Notification (SMN) can send diagnosis exception reports to the preset email address so that you can learn about the overall health status of your instance in real time.

Precautions

After you subscribe to daily reports, the system only emails you if an automated early-morning diagnosis or a manual diagnosis you trigger finds your instance abnormal.

Billing

When you use SMN, only pay for what you use. There are no minimum fees. For details, see Billing.

Instance Diagnosis

  1. Log in to the TaurusDB console.
  2. On the Instances page, click the instance name.
  3. In the navigation pane, choose Daily Reports under DBA Assistant.
  4. Click Start Diagnosis. Select a time range for the diagnosis. The time span is within one day.

    Figure 1 Start Diagnosis

    • You can also click Set to enable AI Anomaly Detection, which performs anomaly analysis on performance metrics during daily report generation.

      AI anomaly detection can analyze the following metrics: CPU usage, memory usage, QPS, TPS, total number of database connections, and number of active connections.

    • If you want to be notified of risks through email, see Subscribing to Diagnosis Reports.

  1. Log in to the TaurusDB console.
  2. On the Instances page, click the instance name.
  3. In the navigation pane, choose Daily Reports under DBA Assistant.
  4. In the Security Score area, check the deducted items and scores. For details about the scoring rules, see Scoring Rules.

    Figure 2 Security Score

  5. Click Performance & Storage, SQL Analysis, or Database/Table Analysis to view the diagnosis report details.

    Figure 3 Performance & Storage

    Move the cursor to the icon next to the metric name to view the upper and lower limits for its high, medium, and low watermarks.

    Figure 4 Viewing watermark ranges

  6. You can also view historical diagnosis reports or download a report to your local PC.

    • To view historical diagnosis reports, click View History in the upper area of the page.
    • To download a report to your local PC, click Download in the upper area of the page.
    Figure 5 Historical Diagnosis Reports

Subscribing to Diagnosis Reports

  1. Log in to the TaurusDB console.
  2. On the Instances page, click the instance name.
  3. In the navigation pane, choose Daily Reports under DBA Assistant.
  4. In the above area of the page, click Subscribe and set subscription parameters. For details about the parameters, see Table 1.

    Figure 6 Subscribe to Daily Reports

    Table 1 Subscription parameters

    Parameter

    Description

    Subscription

    Select By topic or By email.

    Topics

    A topic is used to publish messages and subscribe to notifications. It serves as a message transmission channel between publishers and subscribers.

    If there are no topics you want to select, create one. After a topic is created, click Add Subscription in the Operation column of the topic. In the displayed dialog box, specify a protocol (only Email is supported) and an endpoint.

    Email Addresses

    If you select By email for Subscription, you need to specify Email Addresses.

    An email will be sent to the specified email address only when risks are identified after diagnosis. You can enter up to 15 email addresses and separate each email address with a semicolon (;).

    Store in OBS Bucket

    After this function is enabled, daily reports are generated in PDF format. Upload them to the specified OBS bucket and provide a download link in the email. This function depends on user credentials. You need to configure the AK/SK.

  5. Click OK.
  6. If you want to unsubscribe from diagnosis reports, click Unsubscribe in the upper right corner of the page. In the displayed dialog box, confirm the information and click OK.

Performance and Storage Metrics

Table 2 Metrics

Metric

Description

Handling Suggestion

Reference

TPS

Execution times of submitted and rollback transactions per second
  • Evaluate the SQL execution plan and add indexes to avoid full table scanning.
  • Upgrade vCPUs for compute-intensive workloads.

What Should I Do If the CPU Usage of My TaurusDB Instance Is High?

QPS

Number of SQL queries (including stored procedures) per second

Total Connections

Total number of connections that connect to the TaurusDB database
  • Check whether applications are connected, optimize the connections, and release unnecessary connections.
  • Check the instance specifications and upgrade them if needed.

What Do I Do If There Are Too Many Database Connections?

Current Active Connections

Number of active connections

CPU Usage

CPU usage of the monitored object
  • Evaluate the SQL execution plan and add indexes to avoid full table scanning.
  • Upgrade vCPUs for compute-intensive workloads.

What Should I Do If the CPU Usage of My TaurusDB Instance Is High?

Memory Usage

Memory usage of the monitored object
  • Upgrade instance specifications.
  • Optimize SQL statements to reduce the use of temporary tables.
  • Reconnect sessions at a specific interval to release memory of the sessions.

How Do I Handle a Large Number of Temporary Tables Being Generated for Long Transactions and High Memory Usage?
Parent Topic: Problem Diagnosis