How Do I Set the Session Threshold When Creating Alarm Rules for GaussDB(DWS) in Cloud Eye?
After connecting to a database, run the following SQL statement to check the maximum number of concurrent sessions globally:
show max_active_statements;
Go to the Cloud Eye console and set the threshold to 70% to 80% of the obtained value. For example, if the value of max_active_statements is 80, set the threshold to 56 (80 x 70%).
Procedure:
- On the GaussDB(DWS) console, choose Dedicated Clusters > Clusters.
- Click View Metric in the Operation column of the target cluster to go to the Cloud Eye console.
- Click
in the upper left corner on the displayed page and click Create Alarm Rule of the target cluster.
- Set Method to Configure manually, Metric Name to Session Count, Alarm Policy to 56, and Alarm Severity to Major. Then click Create.
Parent topic: Cluster Management