# Snowflake Virtual Warehouse optimization | Cloud Efficiency Hub Canonical: https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-virtual-warehouse 6 documented Snowflake Virtual Warehouse cost inefficiencies, each with how to detect it and how to fix it. [Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 6 documented Snowflake Virtual Warehouse cost inefficiencies, each with how to detect it and how to fix it. ## 6 inefficiencies [All services](https://www.pointfive.co/efficiency-hub#browse-by-service) - 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 - 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-0141 ### [Inefficient Workload Distribution Across Warehouses](https://www.pointfive.co/efficiency-hub/inefficiencies/inefficient-workload-distribution-across-warehouses) Many organizations assign separate Snowflake warehouses to individual business units or teams to simplify chargebacks and operational ownership. This often results in redundant and underutilized warehouses, as workloads frequently do not... Compute - Snowflake Virtual Warehouse CER-0513 ### [Missing Resource Monitors and Budgets on Snowflake Accounts](https://www.pointfive.co/efficiency-hub/inefficiencies/missing-resource-monitors-and-budgets-on-snowflake-accounts) Snowflake consumption is open-ended by default: any role that can use a warehouse can keep it running, and serverless features and AI services consume credits without a warehouse at all. Without resource monitors or budgets, nothing... Compute - Snowflake Virtual Warehouse CER-0514 ### [Snowflake Multi-Cluster Warehouse Pinned to Maximized Mode](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. When its minimum and maximum cluster counts are set to the same value greater than 1, it runs in Maximized... Compute ## More Snowflake services - [Snowflake Query Processing 3](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-query-processing) - [Snowflake Tables 2](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-tables) - [Snowflake Cortex AI 2](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-cortex-ai) - [Snowflake Automatic Clustering Service 1](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-automatic-clustering-service) - [Snowflake Materialized Views 1](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-materialized-views) - [Snowflake Search 1](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-search-optimization-service) - [Snowflake Snapshots 1](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-snapshots) - [Snowflake Tasks and Pipelines 1](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-tasks-and-pipelines) - [Snowflake Replication 1](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-replication) - [Snowpark Container Services 1](https://www.pointfive.co/efficiency-hub/cloud-services/snowpark-container-services) --- Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.