Help Center> Data Warehouse Service (DWS)> User Guide (Kuala Lumpur Region)> Clusters> Managing Cluster Workloads> Workload Plans
Updated on 2022-08-16 GMT+08:00
View PDF

Workload Plans

Overview

Workload plan is an advanced workload management feature provided by GaussDB(DWS). You can create a workload plan, add multiple stages to the plan, and configure different queue resource ratios for the stages. When a plan is started, it automatically switches the queue resource configurations in different stages. If a customer runs different services in different stages and these services occupy different proportions of resources, the workload plan function can help the customer implement automatic switchover of queue resource configurations in different stages.

Adding Workload Plans

  1. Log in to the GaussDB(DWS) management console.
  2. On the displayed Clusters page, click the name of the target cluster.
  3. Switch to the Workload Management tab page.
  4. Click the plus sign (+) next to Workload Plan to add a workload plan.
  5. Enter a plan name and click OK.

    1. Before creating a workload plan, you must plan and create workload queues. For details, see Adding Workload Queues.

    2. You can create a maximum of 10 workload plans.

Starting Workload Plans

  1. Log in to the GaussDB(DWS) management console.
  2. On the displayed Clusters page, click the name of the target cluster.
  3. Switch to the Workload Management tab page.
  4. Enter the plan details page and click Start to start a workload plan.

    • Only one plan can be started for each cluster.
    • A plan must have at least two stages before it can be started.

Checking Execution Logs of Workload Plans

  1. Log in to the GaussDB(DWS) management console.
  2. On the displayed Clusters page, click the name of the target cluster.
  3. Switch to the Workload Management tab page.
  4. Go to the plan details page and view the switchover logs in the Plan Execution Log area.

Stopping Workload Plans

  1. Log in to the GaussDB(DWS) management console.
  2. On the displayed Clusters page, click the name of the target cluster.
  3. Switch to the Workload Management tab page.
  4. Enter the plan details page and click Stop to stop a workload plan.

Deleting Workload Plans

  1. Log in to the GaussDB(DWS) management console.
  2. On the displayed Clusters page, click the name of the target cluster.
  3. Switch to the Workload Management tab page.
  4. Enter the plan details page and click Delete to delete a workload plan.

    You cannot delete a running workload plan.