# Snowflake Multi-Cluster Warehouse Pinned to Maximized Mode Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/snowflake-multi-cluster-warehouse-pinned-to-maximized-mode A multi-cluster warehouse (Enterprise Edition and above) can run several clusters of the same size to absorb concurrent queries. By: PointFive Updated: 2026-09-28 [Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) The short version A multi-cluster warehouse (Enterprise Edition and above) can run several clusters of the same size to absorb concurrent queries. PointFive Research Cloud cost research at PointFive Snowflake service [Snowflake Virtual Warehouse](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-virtual-warehouse) Category [Compute](https://www.pointfive.co/efficiency-hub/service-category/compute) Reference CER-0514 Type Inefficient Configuration ## Explanation Why the waste happens and who it affects. When its minimum and maximum cluster counts are set to the same value greater than 1, it runs in Maximized mode: Snowflake starts all clusters whenever the warehouse starts and keeps them running while the warehouse runs, regardless of how many queries are actually waiting. Every cluster bills at the full rate for the warehouse size, so a three-cluster Maximized warehouse costs three times a single cluster for every hour it is up. Min and max are often pinned together to avoid any queuing during a known peak, such as a morning dashboard rush, and then never revisit it, so the extra clusters also run through quiet hours, weekends and batch windows when one cluster would serve the load. Snowflake's own Optimization insights flag this configuration as 'Inefficient usage of multi-cluster warehouses' and recommend lowering the minimum cluster count. Maximized mode is still reasonable for workloads with steady, high concurrency throughout the time the warehouse runs. ## Billing model The pricing dimensions that drive this cost. Per-cluster credits Each running cluster consumes credits at the hourly rate of the warehouse size, so total credits are the size rate multiplied by the number of clusters running Maximized mode Minimum equals maximum cluster count; all clusters start with the warehouse and bill for as long as it runs Auto-scale mode Maximum is higher than minimum; clusters start and stop with query load, so credits track actual concurrency Economy scaling policy In Auto-scale mode, starts an extra cluster only if Snowflake estimates enough load to keep it busy for at least 6 minutes ## How to detect 5 checks to find it in your estate. - Review the Optimization insight 'Inefficient usage of multi-cluster warehouses' in Snowsight Admin \> Cost management \> Account Overview, which flags warehouses with identical minimum and maximum cluster counts - Run SHOW WAREHOUSES and list warehouses where min\_cluster\_count equals max\_cluster\_count and both are greater than 1 - Query WAREHOUSE\_LOAD\_HISTORY for those warehouses and compare AVG\_RUNNING and AVG\_QUEUED\_LOAD by hour; low running load and no queuing outside peak hours means the extra clusters are idle - Check CLUSTER\_NUMBER in QUERY\_HISTORY to see how many clusters actually received queries per hour; hours where queries land on only one cluster indicate the others were running without work - Use WAREHOUSE\_METERING\_HISTORY to quantify credits for the warehouse and estimate the share attributable to clusters beyond the first ## How to fix 5 ways to remove the waste. - Switch to Auto-scale mode by lowering the minimum, for example ALTER WAREHOUSE \ SET MIN\_CLUSTER\_COUNT = 1, keeping MAX\_CLUSTER\_COUNT at the level peak concurrency requires - Set MAX\_CLUSTER\_COUNT to observed peak concurrency rather than a generous default; Snowflake suggests starting Auto-scale with a small maximum such as 2 or 3 and adjusting from observed load - Use SCALING\_POLICY = 'ECONOMY' for latency-tolerant workloads such as batch and reporting, accepting some queuing in exchange for fewer cluster starts; keep STANDARD where users need fast response under bursts - If a peak really requires all clusters, raise MIN\_CLUSTER\_COUNT only for that window with a scheduled task and lower it afterwards, instead of pinning it permanently - Confirm the change with WAREHOUSE\_LOAD\_HISTORY queuing metrics after rollout, and revisit whether the warehouse size itself can shrink once concurrency is handled by scaling out ## Documentation Vendor references for pricing and configuration. - [Multi-cluster warehouses docs.snowflake.com](https://docs.snowflake.com/en/user-guide/warehouses-multicluster) - [Using optimization insights to save docs.snowflake.com](https://docs.snowflake.com/en/user-guide/cost-insights) - [ALTER WAREHOUSE docs.snowflake.com](https://docs.snowflake.com/en/sql-reference/sql/alter-warehouse) - [WAREHOUSE\_LOAD\_HISTORY view docs.snowflake.com](https://docs.snowflake.com/en/sql-reference/account-usage/warehouse_load_history) - [Understanding compute cost docs.snowflake.com](https://docs.snowflake.com/en/user-guide/cost-understanding-compute) ## Related inefficiencies [Browse the library](https://www.pointfive.co/efficiency-hub) - Snowflake Virtual Warehouse CER-0132 ### [Suboptimal Warehouse Auto-Suspend Configuration](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-warehouse-auto-suspend-configuration) If auto-suspend settings are too high, warehouses can sit idle and continue accruing unnecessary charges. Tightening the auto-suspend window ensures that the warehouse shuts down quickly once queries complete, minimizing credit waste while... Compute - Snowflake Virtual Warehouse CER-0129 ### [Suboptimal Query Timeout Configuration](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-query-timeout-configuration) If no appropriate query timeout is configured, inefficient or runaway queries can execute for extended periods (up to the default 2-day system limit). For as long as the query is running, the warehouse will remain active and accrue costs.... Compute - Snowflake Virtual Warehouse CER-0168 ### [Underutilized Snowflake Warehouse](https://www.pointfive.co/efficiency-hub/inefficiencies/underutilized-snowflake-warehouse) Underutilized Snowflake warehouses occur when a workload is assigned a larger warehouse size than necessary. For example, a workload that could efficiently execute on a Medium (M) warehouse may be running on a Large (L) or Extra Large (XL)... Compute --- Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.