Quickstart: Pause and resume compute in Synapse SQL pool via the Azure portal

You can use the Azure portal to pause and resume the Synapse SQL pool (data warehouse) compute resources. If you don't have an Azure subscription, create a free account before you begin.

Sign in to the Azure portal

Sign in to the Azure portal.

Before you begin

Use Create and Connect - portal to create a SQL pool called mySampleDataWarehouse.

Pause compute

To reduce costs, you can pause and resume compute resources on-demand. For example, if you won't be using the database during the night and on weekends, you can pause it during those times, and resume it during the day.

Note

You won't be charged for compute resources while the database is paused. However, you will continue to be charged for storage.

Follow these steps to pause a SQL pool:

  1. Sign in to the Azure portal.

  2. Click Azure Synapse Analytics (formerly SQL DW) in the left navigation page of the Azure portal.

  3. Select mySampleDataWarehouse from the Azure Synapse Analytics (formerly SQL DW) page to open the SQL pool.

  4. On the mySampleDataWarehouse page, notice Status is Online.

    Compute online

  5. To pause SQL pool, click the Pause button.

  6. A confirmation question appears asking if you want to continue. Click Yes.

  7. Wait a few moments, and then notice the Status is Pausing.

    Pausing

  8. When the pause operation is complete, the status is Paused and the option button is Resume.

  9. The compute resources for the SQL pool are now offline. You won't be charged for compute until you resume the service.

    Compute offline

Resume compute

Follow these steps to resume SQL pool.

  1. Click Azure Synapse Analytics (formerly SQL DW) in the left page of the Azure portal.

  2. Select mySampleDataWarehouse from the Azure Synapse Analytics (formerly SQL DW) page to open the SQL pool page.

  3. On the mySampleDataWarehouse page, notice Status is Paused.

    Compute offline

  4. To resume SQL pool, click Resume.

  5. A confirmation question appears asking if you want to start. Click Yes.

  6. Notice the Status is Resuming.

    Resuming

  7. When the SQL pool is back online, the status is Online and the option button is Pause.

  8. The compute resources for SQL pool are now online and you can use the service. Charges for compute have resumed.

    Compute online

Clean up resources

You are being charged for data warehouse units and the data stored in your SQL pool. These compute and storage resources are billed separately.

  • If you want to keep the data in storage, pause compute.
  • If you want to remove future charges, you can delete the SQL pool.

Follow these steps to clean up resources as you desire.

  1. Sign in to the Azure portal, and click on your SQL pool.

    Clean up resources

  2. To pause compute, click the Pause button.

  3. To remove the SQL pool so you are not charged for compute or storage, click Delete.

  4. To remove the SQL server you created, click sqlpoolservername.database.windows.net, and then click Delete.

    Caution

    Be careful with this deletion, since deleting the server also deletes all databases assigned to the server.

  5. To remove the resource group, click myResourceGroup, and then click Delete resource group.

Next steps

You have now paused and resumed compute for your SQL pool. Continue to the next article to learn more about how to Load data into SQL pool. For additional information about managing compute capabilities, see the Manage compute overview article.