- About
- Basic Features
- Introduction
- Platform Tenant Management
- Platform User Management
- TOTP Certification
- Basic Data Definition
- Media Management
- Command Management
- Mail Server Configuration
- Job Center
- Platform Host Resource Pool
- Platform Database Pool
- Platform Proxy Nodes Management
- Platform Components Management
- Additional Information Management
- Operation Log
- Connection Concurrency Configuration
- Customization of Platform Styles
- Parameter Templates
- License
- Monitor Large Screen
- Overview Display
- Tenant User Management
- Tenant Host Resource Pool
- Tenant Proxy Nodes Management
- Menu Management
- Report Center
- MogDB/openGauss
- Backup Recovery Center
- Monitoring
- Alert Center
- Inspect Center
Performance Analysis Strategy Management
Function Entrance
Top-right menu --> Settings --> Platform Configuration Management --> Performance Analysis Strategy Management
Function Description
Set and modify database performance analysis strategies, and manage performance analysis strategies. The system defaults to defining a default performance analysis strategy for all databases (by tenant), which cannot be deleted, only modified.
-
By configuring performance analysis strategies, specify performance analysis:
-
Database whitelist
-
Sub-task switch
-
Collection frequency
-
Analysis Top SQL quantity
-
Lifecycle management
-
Performance fluctuation rule definition
-
-
By configuring the relationship between database instances and performance analysis strategies, specify the performance analysis specifications for each database, and manage the performance analysis strategies for database instances.
Operating Instructions
Performance Analysis Strategy List
View the details of the default rules strategy.
Shield Performance Analysis Objects and Collection Switch Control
The Binding Variable SQL PLAN Collection switch can enable the collection of execution plans for SQL with binding variables. When enabled, the SQL execution plan will replace binding variables with fixed values when generating the execution plan. If the replacement fails, the collection of the execution plan fails. Currently, only variables of the following data types are supported for replacement.
Collection Frequency Settings and Rule Definition
