A virtual warehouse initially suffers from poor performance as a result of queries from multiple concurrent processes that are queuing. Over time, the problem resolved.
What action can be taken to prevent this from happening again?
A.
Increase the size of the virtual warehouse.
B.
Add a cluster key to the most used JOIN key.
C.
Change the multi-cluster settings to add additional clusters.
D.
Enable the search optimization service for the underlying tables.
Multi-cluster warehouses are designed specifically for handling queuing and performance issues related to large numbers of concurrent users and/or queries. In addition, multi-cluster warehouses can help automate this process if your number of users/queries tend to fluctuate.
https://docs.snowflake.com/en/user-guide/warehouses-considerations#multi-cluster-warehouses-improve-concurrency
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0e504b5
8 months, 3 weeks agomambamota
9 months ago