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?
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?
When there are many concurrent users and the response time is very slow despite small queries, it is likely that the virtual warehouse is queuing the queries. This means that the warehouse cannot handle all the queries at once, so it queues them, thus increasing the overall execution time for each query.
A is correct
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 look okay