SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ126

Performance, Cost, and Resource Optimization

The Business Intelligence team reports that query response times become significantly slower when some members run dashboard queries in parallel with others.

What can a Snowflake Architect do to determine what is happening and troubleshoot this problem?

Explanation

Multi-cluster warehouses scale out compute capacity for concurrent users and queries. When a single warehouse lacks sufficient resources, queries queue; an auto-scaling multi-cluster warehouse can start additional clusters as concurrency rises. Query history and warehouse-load data can be used to identify the concurrent workload and overload queuing. Snowflake does not provide a warehouse-cache-size setting to tune for concurrency.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!