Warehouse Tuning

Optimize warehouse sizing, auto-suspend, and scaling configuration

Total Warehouses

4

Need Attention

2

Potential Savings

$39.8K/mo

Avg Utilization

48%

Monthly Spend

$150K

Warehouses

Select a warehouse to configure

ANALYTICS_WHNeeds Tuning

Size:X-Large

Suspend:300s

Utilization23%

$45,000/moSave $22.5K

ETL_WHReview

Size:2X-Large

Suspend:600s

Utilization67%

$89,000/moSave $15.0K

REPORTING_WHOptimized

Size:Medium

Suspend:60s

Utilization89%

$12,000/mo

DEV_WHNeeds Tuning

Size:Small

Suspend:900s

Utilization12%

$3,500/moSave $2.3K

ANALYTICS_WH

Configuration and recommendations

Warehouse SizeRecommended: Large

Auto-Suspend300s

60s (Aggressive)900s (Conservative)

Recommended: 60s based on usage patterns

Auto-Resume

Resume when queries arrive

Multi-cluster Warehouse

Auto-scale clusters for concurrency

Query Acceleration

Enable serverless compute for large queries

Utilization

23%

Peak: 78%

Idle Time

67%

Wasted credits

Queries/Hour

145

Avg queue: 2.3s

Credits Used

4,500

This month

Cost Impact

Current Monthly

$45,000

After Optimization

$22,500

Potential savings: $22,500/mo