Blog Post

Azure Database Support Blog
3 MIN READ

Auto scale up/down the Managed instance

amanda_ibrahim's avatar
amanda_ibrahim
Icon for Microsoft rankMicrosoft
Sep 20, 2022
Request: If the customer needs to configure auto scaling for SQL Managed Instance, where the vCores can be increase and decrease automatically on specific time.   Solution: You may take a loo...
Updated Sep 20, 2022
Version 2.0
Alan_Niedelman's avatar
Alan_Niedelman
Copper Contributor
Aug 10, 2023

It appears to be working but it's not actually scaling the Managed Instance. Ran Set-AzSqlInstance comand with same the parameters from powershell without issue.

[8/10/2023 6:46:31 PM]: MI name: xxxxxxx
[8/10/2023 6:46:31 PM]: Current MI vCores: 8, Storage: 1024
[8/10/2023 6:46:31 PM]: ---> Scaling schedule found. Check if current edition/tier is matching... 
[8/10/2023 6:46:31 PM]: --- ---> vCores and/or Storage Size are different. Changing!
[8/10/2023 6:46:33 PM]: Change to vCores/Sotrage size as specified in scaling schedule initiated...
[8/10/2023 6:46:33 PM]: Current MI vCores: 8, Storage: 1024
[8/10/2023 6:46:33 PM]: Script finished.