Skip to content

Features

Top N query rankings

Quickly identify queries that are driving execution time, compute usage, scanning volume, spillage, or queuing.

Cost attribution

Analyze compute-heavy workloads by dimensions such as:

  • Warehouse
  • User
  • Role
  • Query type
  • Query tag

This helps teams determine where Snowflake compute is being consumed.

Spillage detection

PerfScope highlights queries exhibiting local or remote storage spillage.

Spillage can indicate that a query:

  • Needs additional memory
  • Is processing excessive intermediate data
  • Could benefit from query optimization
  • Is running on an undersized warehouse

Queuing analysis

Warehouse queuing can indicate concurrency pressure.

PerfScope helps surface queries experiencing queue time so teams can investigate:

  • Warehouse sizing
  • Multi-cluster configuration
  • Workload scheduling
  • Workload isolation

Trend analysis

Historical views help identify query-performance changes over time.

Use these views to spot:

  • Increasing execution time
  • Growing scan volume
  • Rising resource consumption
  • Recurring workload spikes
  • Warehouse pressure

Snowflake-native architecture

PerfScope is designed as a Snowflake Native App.

Its core performance-analysis workflow executes inside the consumer's Snowflake environment, reducing the need for external infrastructure and data movement.