SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ23

Performance, Cost, and Resource Optimization

Which query identifies the particular days and virtual warehouses that could benefit from a multi-cluster warehouse to improve performance for a specific workload?

Explanation

WAREHOUSE_LOAD_HISTORY records AVG_QUEUED_LOAD, the query load queued because a warehouse was overloaded. Grouping that history by date and warehouse and retaining groups with a positive summed queued load identifies the days and warehouses experiencing overload-related queueing—the condition for which multi-cluster warehouses can add concurrency. Snowflake documents this same query pattern for finding warehouses with queueing.

Learn more

Community Discussion

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