Forum Discussion
Solved
Dedicated SQL Pool Automation
I have pipelines running that will turn on/off the dedicated SQL pool. I tried to add in the parameter and call to be able to scale up and down. When it gets to the point of scaling, it fails du...
- Reviewed the following link and was able to get things to work: https://learn.microsoft.com/en-us/answers/questions/1191295/how-to-auto-scaleup-and-scaledown-the-dwu-in-azure
1) Where is this applied to (within Azure or within the DB)?
2) If this is within the DB, is there a TSQL syntax/reference to add this same permission?
When looking for the exact path you mentioned, there is limited information on how to apply this. Also, will this work for a Synapse dedicated SQL pool or only Azure SQL ?
2) If this is within the DB, is there a TSQL syntax/reference to add this same permission?
When looking for the exact path you mentioned, there is limited information on how to apply this. Also, will this work for a Synapse dedicated SQL pool or only Azure SQL ?
Reviewed the following link and was able to get things to work: https://learn.microsoft.com/en-us/answers/questions/1191295/how-to-auto-scaleup-and-scaledown-the-dwu-in-azure