Difference between revisions of "Amazon Redshift workload management (WLM)"

From wikieduonline
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
WLM types:
 
WLM types:
* Automatic (default)
+
* Automatic (default) (Sep 2019 <ref>https://aws.amazon.com/about-aws/whats-new/2019/09/amazon-redshift-announces-automatic-workload-management-and-query-priorities/</ref>)
 
* Manual
 
* Manual
  
  
  
  select * from stv_wlm_service_class_config  
+
  select * from stv_wlm_service_class_config where service_class >= 100;
where service_class >= 100;
+
https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html
 +
 
 +
* [[Amazon Redshift metrics]]:
 +
** <code>WLMQueueLength</code>
 +
** <code>WLMQueueWaitTime</code>
 +
** <code>WLMQueriesCompletedPerSecond</code>
  
 
== See also ==
 
== See also ==

Latest revision as of 11:19, 31 January 2022

Advertising: