How to use Amazon Redshift Workload Management (WLM) for Advanced Monitoring and Performance Tuning

Рет қаралды 7,721

Күн бұрын

#performance #wlm #redshift
In this webinar, we go over the best practices for using the workload manager (WLM) in Amazon Redshift to process a massive volume of queries in short time, discover and prevent problems with your cluster and run blazing fast dashboards for your data consumers.
More information:
If you’re ready to implement proper workload management for your Redshift cluster, start your free trial with intermix.io: www.intermix.io/workload-mana...
Download a Free WLM Planning Worksheet to track changes and their effect: docs.google.com/spreadsheets/...
Further reading:
4 Simple Steps To Set-up Your WLM in Amazon Redshift For Better Workload Scalability: www.intermix.io/blog/4-simple...
Top 14 Performance Tuning Techniques for Amazon Redshift: www.intermix.io/blog/top-14-p...
A Quick Guide to Using Short Query Acceleration and WLM for Amazon Redshift for Faster Queries: www.intermix.io/blog/quick-gu...
Subscribe for more content: / @intermixsoftware2634

Пікірлер: 11

@lucazarts25 2 ай бұрын

Hands down the best content out there at conceptual and, I must add 'quite practical' level regarding WLM. Thank you and congrats!

@ashishpataskar1069 5 жыл бұрын

This is the Best explanation on WLM concepts.

@unclassifiedclips 3 жыл бұрын

White lives matter⚡🤙🏻

@ghub4445 5 жыл бұрын

This is an excellent demonstration of WLM in redshift. You saved me some reading. Thanks..Much appreciated for this great presentation.

@sunshadow9704 4 жыл бұрын

very clear explanation. Thank you Sir. It would help if you run brief demo where you apply these steps on real RS cluster.

@maheshpoddar4065 3 жыл бұрын

At 6:05, in this video, it is said that the load query(5) won't run next 4-5 minutes. This does not seem to be correct. Once both the Adhoc queries(20) get over in next 20 seconds, next two more Adhoc queries(20) will come and finish in the next 20 seconds. And then extract queries(5) will start and finish in the next 5 seconds. I.e. extract queries just had to wait for 40 seconds; not 4-5 minutes. Appreciate it if the presenter can take a look here.

@elektrazap1 2 жыл бұрын

agree. This video only confuses me even more