Azure Synapse Dedicated SQL Pool Auto Pause

Anonymous
2023-04-10T20:35:35.24+00:00

Hello, I am running an Azure Synapse workspace. I created a dedicated SQL Pool. Is there a way to auto pause the dedicated sql pool to reduce costs? Thank You, Michael

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 29,266 Reputation points Microsoft Employee
    2023-04-11T00:19:54.01+00:00

    Hello Michael Stoler You can pause and resume dedicated SQL pools with synapse pipelines. The document below has detailed steps to guide you through setting up the automated pause and resume. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/how-to-pause-resume-pipelines I hope this helps. Please let me know if you have any further questions.