Skip to main content

Adaptive Query Scaling

Adaptive Query Scaling (AQS) is an advanced feature provided by Relyt to ensure the smooth running and stable performance of your DPS clusters. It assures a sound availability of 99.9% for a single DPS cluster.

Overview​

AQS can identify large queries during runtime and send them to be processed in a shared compute resource pool offered by this feature. This enables your DPS cluster to run normally and stably whenever workload bursts occur.

With AQS enabled, the following two types of queries running on your DPS cluster will be identified as large queries:

  • Queries that cannot be processed properly by the given DPS cluster due to resource limitations such as "not enough memory".
  • Queries whose running affects the performance of the given DPS cluster.

Usage notes​

Enabling the AQS feature itself incurs no fees. You are charged only for the shared compute resources are used to process large queries.

AQS always chooses the most efficient amount of compute resources to process your large queries. However, to help you better manage your cloud budget, AQS requires you to set an upper limit for the shared compute resources that AQS can use when you enable AQS for your DPS cluster.

When using AQS, note the following restrictions:

  • Currently, AQS can only be enabled for Extreme DPS clusters.
  • AQS is enabled on a per-DPS cluster basis. If you want to enable AQS on multiple DPS clusters, you must enable it for each of them.
  • AQS can only be enabled during DPS cluster creation. If you want to enable AQS for an existing DPS cluster, you need to drop the DPS cluster first and recreate it again.

Enable AQS for your Extreme DPS cluster​

The following procedure details how to create an Extreme DPS cluster with AQS enabled.

  1. Sign in to the Relyt console and connect to the target DW service unit.

  2. On the DW service unit home page, select DPS Clusters from the left sidebar.

  3. Click + DPS Cluster to enter the Create DPS Cluster page.

  4. Specify the DPS cluster information. Specifically, expand the Advanced Options area, turn on Adaptive Query Scaling and set the upper limit for additional compute resources that Relyt can use to process routed large queries.

    For more information about other parameters, see DPS Clusters.

  5. Click Create.

After the Extreme DPS cluster is created, AQS is in effect.