Top Gradient
Back

Warehouse Cluster Utilization Metrics

Sunday, April 21, 2024

  • Author
    Niall WoodwardCo-founder & CTO of SELECT

When using multi-cluster warehouses, the max_cluster_count setting can have significant implications on both cost and performance.

To help users make more informed decisions around this setting, we’ve released a brand new Cluster Utilization Tab to the Warehouses page.

You’ll see a number of helpful metrics including:

  • Spend per cluster
  • Idle time spend per cluster
  • Utilization efficiency per cluster
  • Warehouse queuing metrics
  • Average number of queries running per cluster

If you see clusters with low utilization efficiency and high idle-time costs, consider reducing the max_cluster_count setting to avoid unnecessary spending. Leverage the query queueing and other performance metrics we surface to validate your changes haven’t had any unacceptable implications on performance.

Up next.Previous Changelog Entries.

Get up and running in less than 15 minutes

Connect your Snowflake account and instantly understand your savings potential.

CTA Screen