There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very slow.
What is causing this to occur?
A.
The warehouse is queuing the queries, increasing the overall query execution time.
B.
The warehouse parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set too low.
C.
The application is not using the latest native ODBC driver which is causing latency.
D.
The queries are not taking advantage of the data cache.
I choose A although D in my opinion is also correct.
B - STATEMENT_QUEUED_TIMEOUT_IN_SECONDS - from snowflake:
"Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAX_CONCURRENCY_LEVEL parameter to ensure a warehouse is never backlogged."
D - if queries do not take advantage of cached results, it causes the queries to be fully executed --> meaning, they take compute resources and time.
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.
yaho5
7 months agoMultiCloudIronMan
1 year, 6 months agobarti12
1 year, 7 months ago