0

I'm pretty new to Synapse but we are looking for a script to shutdown/startup Synapse during non business hours. This is to help reduce our costs during evenings and weekends.

Any assistance would be appreciated.

Is anyone aware of a script that could assist with this?

Dave
  • 1

1 Answers1

0

You can utilize Azure Synapse pipelines to automate the pausing and resuming of your Synapse Dedicated SQL pool.

In order to do that first you will have to create a pipeline, then identify the list of dedicated SQL pools in your Azure Synapse workspace. Next filter any dedicated SQL pools that you don't want to pause or resume from the list and then loop over each dedicated SQL pool and next check the state of each dedicated SQL pool, evaluate the state of the dedicated SQL pool and make a decision whether to pause or resume the dedicated SQL pool based on the business need. The pipeline flow looks like below:

enter image description here

This pipeline flow will utilize below REST API's to list, check state and then pause or resume your Dedicated SQL pools.

Here is a public documentation which is a sample demonstration on how to setup the pipeline to automate the process using Synapse pipelines.

Pause and resume dedicated SQL pools with Synapse Pipelines

Here is a techcommunity article by one of the MSFT which uses script to automate the pausing and resuming of Synapse Dedicate SQL pools: Automatic pause all Synapse Pools and keeping your subscription costs under control

Kranthi Pakala
  • 1,288
  • 5
  • 10