Hello,
We have set up Redshift and are trying to implement WorkLoadManagement. We have set out Concurrency Scaling mode to auto using manual and auto WLM. Tested both but Concurrency Scaling does not add additional cluster during spike.
Upon adding load onto the Redshift Cluster, the CPU Utilisation hits the 100% mark but upon checking the workload concurrency no additional clusters have been added.
In my WLM Parameters, i have added max_concurrency_scaling_clsuters to 4. However, when the CPU Utilisation hits 100% for the compute nodes, a additional clusters does not get added under Workload Concurrency
What could I be missing in my configuration that doe not allow an additional cluster to be added during a spike?
https://stackoverflow.com/questions/65129469/aws-redshift-concurrency-scaling-not-adding-clusters-during-spike -- Link. to question asked on stackoverflow with attachments