Generating an Active Session Profile
Scenarios
You can collect and download active session profiles (ASPs) on the GaussDB console.
Constraints
The DB engine version of GaussDB instances must be V2.0-3.300 or later, and the kernel version must be 503.2 or later. For details about how to query the version, see Checking the DB Engine and Kernel Engine Version of a GaussDB Instance.
Precautions
- After ASP Generation is enabled, ASP data is sampled every second.
- If ASP Generation is disabled, there may be no data available when the data source is set to template-collected data for SQL diagnosis and slow SQL data collection.
- The default collection period is the latest 2 hours and the maximum length is two days.
- The collected ASP reports are retained for three days by default.
Procedure
- Log in to the management console.
- Click
in the upper left corner and select the desired region and project.
- Click
in the upper left corner of the page and choose .
- On the Instances page, click the name of the target instance to go to the Basic Information page.
- In the navigation pane, choose Diagnostics and Optimization > Performance Reports. Then, click the Active Session Profile tab.
- Select the collection period and click Generate ASP.
Figure 1 Generating an ASP
- Refresh the instance later and view the collection result.
- If the collection is successful, click Download ASP to obtain the ASP of the specified period.
- If the collection failed, contact Huawei Cloud customer service.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot