If there is queueing in the virtual warehouse load monitoring chart, what should a Snowflake user do?
If there is queueing in the virtual warehouse load monitoring chart, what should a Snowflake user do?
If there is queuing in the virtual warehouse load monitoring chart, a Snowflake user should change the multi-cluster settings to add additional clusters. This will help handle higher concurrency and distribute the load more effectively within the same warehouse, preventing queuing due to high query load.
Both C & D are correct. C: If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. D: Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward.
It's queuing issue hence you dont need new warehouse but need additional clusters within same warehouse. And as queries are already in system hence can't move queries to new warehouse without killing and resubmitting.
https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring Slow Query Performance When you notice that a query is running slowly, check whether an overloaded warehouse is causing the query to compete for resources or get queued: If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward.
Above is a a direct quote. C) would assume the cluster is a multi-cluster one. We do not seem to be able to assume that in here.
there is no add additional compute, but we can configure max or min warhouse
D. It is a query queuing due to load, not an concurrency issue.
correct
Correct
Correct -- D If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward.