Workload Management
Workload Management (WLM) is a powerful tool in Amazon Redshift that manages multiple types of workloads. By creating queues with appropriate resource allocations and concurrency limits, you can ensure that your system runs efficiently, even under heavy load.
Types of Workload Management in Amazon Redshift
Amazon Redshift offers two WLM modes:
1) default (Automatic WLM)
2) User base (Manual WLM)
when we use default WLM :
Automatic WLM dynamically manages query concurrency and memory allocation without manual intervention. It adjusts the system to optimize performance based on the workload at any given time.
Key Features:
- Dynamic query allocation.
- Automatic resource optimization.
- Minimal configuration effort.
Use Case:
Scenario: A retail company experiences unpredictable query patterns during seasonal sales. Queries can range from lightweight ad-hoc analyses to heavy-duty reporting during peak hours.
- Solution: With Automatic WLM, Redshift dynamically adjusts the number of concurrent queries and allocates resources as required. During peak hours, more resources are allocated to heavier queries, ensuring seamless performance without manual tuning.
when we use User based WFM :
Automatic WLM dynamically manages query concurrency and memory allocation without manual intervention. It adjusts the system to optimize performance based on the workload at any given time.
Key Features:
- Dynamic query allocation.
- Automatic resource optimization.
- Minimal configuration effort.
Use Case:
Scenario: A retail company experiences unpredictable query patterns during seasonal sales. Queries can range from lightweight ad-hoc analyses to heavy-duty reporting during peak hours.
- Solution: With Automatic WLM, Redshift dynamically adjusts the number of concurrent queries and allocates resources as required. During peak hours, more resources are allocated to heavier queries, ensuring seamless performance without manual tuning.
//----