Skip to main content

Documentation

Overview​

Connecting to Snowflake​

Virtual Warehouses​

Databases, Tables, & Views​

Data Types​

Data Loading​

Data Unloading​

Queries​

Snowflake Cortex ML-Based Functions​

Data Sharing & Collaboration​

Alerts & Notifications​

Security​

Data Governance​

Organizations & Accounts​

Business Continuity & Data Recovery​

Performance Optimization​

Memory Spillage​

Performance degrades drastically when a warehouse runs out of memory while executing a query because memory bytes must “spill” onto local disk storage. If the query requires even more memory, it spills onto remote cloud-provider storage, which results in even worse performance.

Options for Resolving Memory Spillage​

When memory spillage is the issue, you can convert your existing warehouse to a Snowpark-optimized warehouse, which provides 16x more memory per node and 10x the local cache compared to a standard warehouse. Though a larger warehouse also has more memory available, a query might not require its expanded compute resources.

If you want to try resolving the spillage of a query without adjusting the warehouse that runs it, use the Query Profile to identify which operation nodes are causing the spillage.

Performance impact from local and remote disk spilling

Resolving memory spillage | Snowflake Documentation

Cost Management​