Data Management (DMS) integrates specific features of Database Autonomy Service (DAS) to help you obtain up-to-date information about the performance of a database instance and optimize the database instance in a quick, accurate, and effective manner.

Prerequisites

  • If the database instance is managed in Flexible Management or Stable Change mode, make sure that you have the permission to log on to the database instance. After the logon, you can view the performance details of the database instance.
  • If the database instance is managed in Security Collaboration mode, make sure that you have the permission to manage the performance of the database instance. Then, you can view the performance details of the database instance.

Background information

DAS is a cloud service that automates perception, healing, optimization, O&M, and security management for databases based on machine learning and expert experience. DAS simplifies database management and prevents service failures that may be caused by manual operations. This allows you to ensure the stability, security, and efficiency of your database service. DAS provides various features such as one-click diagnostics, real-time performance monitoring, instance session management, and storage analysis. These features help you obtain information about the performance of database instances and troubleshoot issues at the earliest opportunity to ensure service security and stability.

Features

Feature Description
One-click diagnostics You can use this feature to identify performance issues in your database instances. For more information, see Diagnostics.
Real-time performance monitoring You can use this feature to view the performance metrics of each database instance that is connected to DAS in real time. For more information, see Real-time monitoring.
Instance session management You can use this feature to view the information about the sessions between a database instance and a client in real time. The information includes the client information, the commands that are run, and the connection duration. You can also terminate abnormal sessions based on business requirements. For more information, see Session management.
Storage analysis You can use this feature to view the storage usage of a database instance and the number of days for which the remaining storage of the database instance is available. This feature also provides the storage information about each table in a database, such as the storage usage, information about tablespace fragments, and diagnostic reports on storage exceptions. For more information, see Storage analysis.
Note For more information about the description of the database performance, see Database engines and features supported by DAS.

Procedure

  1. Log on to the DMS console V5.0.
  2. Use one of the following methods to go to the DAS console:
    • Method 1:
      1. In the upper-left corner of the DMS console, search for the database instance whose performance details you want to view by entering keywords in the search box.
        Note You can enter the name, endpoint, or type of the database instance as a keyword.
      2. Under the name of the database instance, right-click the database whose performance details you want to view. Then, move the pointer to Performance and select the feature that you want to use to go to the DAS console.
    • Method 2:
      1. In the top navigation bar of the DMS console, choose SQL Console > SQL Console.
      2. In the Please select the database first dialog box, enter a keyword to search for the required database instance, select the database instance from the search results, and then click Confirm.
      3. In the extended feature section that is in the upper-right corner of the SQL Console page, click the Data analysis icon icon to go to the DAS console.
    • Method 3:
      1. In the top navigation bar of the DMS console, click Data Assets. In the left-side navigation pane, click Global Search.
      2. On the Global Search page, enter keywords in the search box to search for the required database instance.
        Note Fuzzy match is supported.
      3. In the search results, find the required database instance and click Performance in the Actions column to go to the DAS console.