# Inefficient Workload Distribution Across Warehouses

Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/inefficient-workload-distribution-across-warehouses

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

# Inefficient Workload Distribution Across Warehouses

## Explanation

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 require the full capacity of even the smallest warehouse size.

By consolidating compatible workloads onto shared warehouses, organizations can maximize utilization, reduce idle runtime across the fleet, and significantly lower total credit consumption. Cost allocation can still be achieved using Query Billing Attribution.

## Relevant Billing Model

## Detection

- Review warehouse usage patterns to identify warehouses operating consistently below concurrency capacity (e.g., low simultaneous query counts).

- Evaluate whether workloads running on separate warehouses have compatible scheduling, priority, or SLA needs that allow consolidation.

- Assess existing query queuing or resource contention risks before consolidation to avoid performance degradation.

- Validate with workload owners that consolidation would not introduce unacceptable performance risks.

## Remediation

- Consolidate compatible workloads onto shared warehouses to improve overall utilization without sacrificing performance.

- Adjust warehouse sizing or enable multi-cluster scaling if necessary to accommodate increased concurrency after consolidation.

- Validate SLA and performance expectations with all impacted business units or workload owners prior to consolidation.

- Use Query Billing Attribution to maintain accurate cost allocation across teams sharing a consolidated warehouse.

## Relevant Documentation

- [Warehouse Load History](https://docs.snowflake.com/en/sql-reference/account-usage/query_attribution_history)

- [Query Cost Attribution](https://docs.snowflake.com/en/sql-reference/account-usage/query_attribution_history)

[Submit Feedback](https://hub.pointfive.co/inefficiencies/inefficient-workload-distribution-across-warehouses)

## At a glance

Reference

CER-0141

Cloud provider

Snowflake

Service

Snowflake Virtual Warehouse

Category

[Compute](https://www.pointfive.co/efficiency-hub/service-category/compute)

Inefficiency type

Underutilized Resource

## Contributed by

- Simar Arora 

### Simar Arora

Value Engineer - FinOps @ Snowflake

[LinkedIn](https://www.linkedin.com/in/simarpreet-arora/)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.