SQL Probes

Updated on 2025-03-03 GMT+08:00

View PDF

You can upload and verify SQL probes, execute probe tasks in one click, and periodically execute probe tasks. Alarms can be reported for timeout SQL probes. The procedure is as follows:

Adding a SQL Probe
Enabling or Disabling a SQL Probe
Modifying an SQL Probe
Deleting a SQL Probe
Executing a SQL Probe in One Click

NOTE:

The SQL probe is supported only in 8.1.1.300 and later versions. To use it in earlier versions, contact technical support.
Only SELECT statements can be used as SQL probes.
Up to 20 SQL probes can be configured.
To create an SQL probe, you must have the GaussDB(DWS) FullAccess permission.
To enable the SQL probe function, choose Monitoring Settings > Monitoring Collection and enable the SQL Probe metric. For details, see Monitoring Collection. The default collection frequency is 30s.

Adding a SQL Probe

Log in to the GaussDB(DWS) console.
Choose Dedicated Clusters > Clusters and locate the cluster to be monitored.
In the Operation column of the target cluster, click Monitoring Panel.
In the navigation pane, choose Utilities > SQL Probes. Click Add SQL Probe.
Configure SQL probe parameters.
- Probe Name: Name of a probe.
- Database: Database where the probe SQL statement is to be executed.
- SQL Statement: Probe SQL statement to be executed. (Only SELECT statements are allowed).
- Probe Threshold (ms): Timeout threshold of probe SQL execution.
- Description: Probe SQL statement description.
Confirm the SQL probe information and click Confirm.

Enabling or Disabling a SQL Probe

Log in to the GaussDB(DWS) console.
Choose Dedicated Clusters > Clusters and locate the cluster to be monitored.
In the Operation column of the cluster, choose Monitoring Panel. The database monitoring page is displayed.
In the navigation pane on the left, choose Utilities > SQL Probes.
In the probe list, click Enable (or Disable) in the Operation column of a probe.
Confirm the information and click OK.

Modifying an SQL Probe

Log in to the GaussDB(DWS) console.
Choose Dedicated Clusters > Clusters and locate the cluster to be monitored.
In the Operation column of the cluster, choose Monitoring Panel. The database monitoring page is displayed.
In the navigation pane on the left, choose Utilities > SQL Probes.
In the probe list, click Modify in the Operation column of a probe.
On the Modify Probe page, modify the SQL probe parameters as required and click OK.

Deleting a SQL Probe

Log in to the GaussDB(DWS) console.
Choose Dedicated Clusters > Clusters and locate the cluster to be monitored.
In the Operation column of the cluster, choose Monitoring Panel. The database monitoring page is displayed.
In the navigation pane on the left, choose Utilities > SQL Probes.
In the probe list, click Delete in the Operation column of a probe.
Confirm the information and click OK.

Executing a SQL Probe in One Click

Log in to the GaussDB(DWS) console.
Choose Dedicated Clusters > Clusters and locate the cluster to be monitored.
In the Operation column of the cluster, choose Monitoring Panel. The database monitoring page is displayed.
In the navigation pane on the left, choose Utilities > SQL Probes.
In the probe list, select a probe and click Run. The system will execute the selected probe and update information about the probe.
Confirm the information and click OK.

Parent topic: Utilities

Previous topic: SQL Diagnosis

Next topic: Table Diagnosis

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot