question

JayeshDave-8716 avatar image
0 Votes"
JayeshDave-8716 asked HimanshuSinha-MSFT commented

Scripting Auto Pause & Resume for two azure services

Hello All:

I am looking for script that can auto pause & resume Azure Synapse Dedicated SQL Pool & Azure ML Compute Node.

I need a pointer and or a link which will help me to get a head start.

Any help or link is greatly appreciated.

Thanks

azure-synapse-analytics
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello Himanshu:

Thanks for the link and I am aware of it.

I was looking more in terms of scripts.

As i am not seeing in document, do we have ARM template for "Pause and resume dedicated SQL pools with Synapse Pipelines" ????

Thank you for your help.

0 Votes 0 ·

Hello @SunShine-2583 ,
Thanks for the clarification , but at this time AFAIK , there is NO ARM template for Resume and Pause activity .
Thanks
Himanshu

1 Vote 1 ·

Hello Himanshu:

Thanks for the link and I am aware of it.

I was looking more in terms of scripts.

As i am not seeing in document, do we have ARM template for "Pause and resume dedicated SQL pools with Synapse Pipelines" ????

Thank you for your help.

0 Votes 0 ·

Thanks for clarifying the ask . Unfortunately we do not have any ARM template for this .ARM templates are more on the deplyment kind of task .

Thanks
Himanshu

0 Votes 0 ·
JayeshDave-8716 avatar image
0 Votes"
JayeshDave-8716 answered JayeshDave-8716 edited

Hello:

I was able to find python commands in Microsoft Documentations, I need help for scripting on Azure Synapse.

How to stop Azure ML Compute Instance using Python. (I hope it will help others)
https://github.com/dem108/azureml-compute-instance-mgmt

  • get_status() gets the latest status of the ComputeInstance target
    instance.get_status()

  • stop() is used to stop the ComputeInstance

  • Stopping ComputeInstance will stop the billing meter and persist the state on the disk.

  • Available Quota will not be changed with this operation.
    instance.stop(wait_for_completion=True, show_output=True)


  • start() is used to start the ComputeInstance if it is in stopped state
    instance.start(wait_for_completion=True, show_output=True)


  • restart() is used to restart the ComputeInstance
    instance.restart(wait_for_completion=True, show_output=True)

Thanks

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered

Hello @JayeshDave-8716,
Thanks for the ask and using the Microsoft Q&A platform .
Just wanted to point you to the below document , Its should help .

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/how-to-pause-resume-pipelines#:~:text=Pause%20and%20resume%20for%20dedicated,an%20existing%20data%20orchestration%20process.

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.