# Auto Shutdown

## Overview

Auto Shutdown ensures warehouses are shut down immediately when they become idle — without interrupting active queries.\
By continuously monitoring your workloads and historical activity, it eliminates unnecessary compute costs while maintaining full performance and stability.

***

## How It Works

### Smarter Auto-Suspend Control

Seemore overrides Snowflake’s built-in auto-suspend logic with a dynamic mechanism.\
When a warehouse becomes idle, Seemore automatically adjusts the suspend value down to **1 second**, ensuring it is suspended almost instantly.\
This is a **graceful shutdown** — running queries always complete before suspension.

***

### Smart Idle Detection

Seemore monitors warehouse activity every few seconds to identify idle periods.\
When no queries are active, the warehouse is suspended safely, reducing cost without affecting performance.

***

### Cost-Free Monitoring

Seemore runs lightweight internal checks that read only **metadata and configuration details**.\
This means:

* Warehouses are never reactivated by monitoring.
* The process is **completely cost-free**.
* Performance remains unaffected.

***

## Benefits

* **15–20 % compute savings** on average with zero configuration overhead
* **Non-intrusive operation** — never terminates active queries
* **Fully automated** — continuously manages suspension in real time

***

## Prerequisites

Auto Shutdown requires the `MANAGE WAREHOUSES` privilege. If you haven't already granted it during initial setup, run:

```sql
GRANT MANAGE WAREHOUSES ON ACCOUNT TO ROLE seemore_user_role;
```

For full setup instructions, see [Create Snowflake User and Privileges](https://docs.seemoredata.io/external-docs/fundamentals/getting-set-up/setting-integrations/snowflake/create-snowflake-user-and-privileges).

***

### How to Turn It On

<figure><img src="https://3620459840-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnSbIoBjUxWTGNWa9gGw7%2Fuploads%2FDJ471XzvWzUaMyF3vigY%2FDashboard%20-%205%20November%202025.gif?alt=media&#x26;token=8954a6af-b3e3-43af-b00b-ab8f06ba33d1" alt=""><figcaption></figcaption></figure>

#### Step 1 — Open the Compute Dashboard

Navigate to **Cost Overview → Compute**.\
This screen lists all Snowflake warehouses along with their cost metrics and optimization options.

***

#### Step 2 — Review Total Savings

At the top of the screen, review your **total potential savings**, including those achievable with Auto Shutdown.

***

#### Step 3 — Enable Auto Shutdown

You can activate Auto Shutdown in two ways:

* **All warehouses -** Apply Auto Shutdown globally for all warehouses per account.
* **Per warehouse:** Locate the warehouse in the list and toggle **Auto Shutdown** to **ON**.

***

#### Step 4 — Automatic Operation

Once activated, Seemore immediately begins monitoring and will suspend each warehouse whenever it becomes idle.

> \[!NOTE] You can return to the **Compute** screen anytime to track results or adjust Auto Shutdown for specific warehouses.

***

## Monitoring & Validation

* Warehouse Cost Overview – Includes two idle-time monitoring graphs that can be found in the configuration section of each warehouse page by clicking on 'show idle info':

  * *Average idle time per session* by percentiles (P50 / P90 / P95).
  * *Idle time vs. execution time* to show how much idle compute is eliminated.

  <figure><img src="https://3620459840-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnSbIoBjUxWTGNWa9gGw7%2Fuploads%2FYciygpjEQHtBI7DEPjh7%2Fimage.png?alt=media&#x26;token=72d2fe19-2067-46d0-a131-f01e8c6a482b" alt=""><figcaption></figcaption></figure>
* **Insights page** -Displays total cost reduction and cumulative savings achieved through Auto Shutdown.
* **Warehouse Cost Overview** - Includes an **Event Log** that records every configuration change for full visibility.

> \[!TIP] Combine Auto Shutdown with SmartPulse for maximum savings — Auto Shutdown eliminates idle cost, while SmartPulse optimizes active workloads.

***


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.seemoredata.io/external-docs/fundamentals/our-features/automations/auto-shutdown.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.