A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?

Question

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Sergey Aleksandrov · Accepted Answer

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

Sergey Aleksandrov · Answer

Increase the warehouse size from Medium to 2XL.

Sergey Aleksandrov · Answer

Configure the warehouse to a multi-cluster warehouse.

Sergey Aleksandrov · Answer

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

List of questions