Using Redshift workload management (WLM) to manage workload priority
Amazon Redshift’s WLM feature is designed to help manage and prioritize queries and other database operations. By enabling and configuring WLM, users can ensure critical queries receive the necessary resources without being stalled by other less urgent processes. This recipe will guide you through setting up WLM, including the configuration of automatic WLM, to manage workloads in your Redshift environment efficiently.
Getting ready
Before configuring WLM in Amazon Redshift, you must have administrative access to your Redshift cluster and the AWS Management Console. Ensure your Redshift cluster is operational and you have familiarized yourself with the basic concepts of how Redshift handles queries and operations.
How to do it…
- Log in to the Redshift management console.
- Navigate to your cluster, click on Configurations as shown, and click on Workload management:
...
