Forum Discussion
Azure SQL Managed Instance Auto-Scaling
Hi,
I'm looking for a solution for Auto-Scaling to Azure SQL Managed Instance but didn't found any possible way out.
Please help.
Regards,
Muhammad Uzair
3 Replies
- There are 2 potential options for scaling which we know it as Scale Up and Scale Out... These options are also available basis the pricing tier you choose e.g. General Purpose Vs Business Critical. This best practices way to achieve it is to leverage automation/runbooks that are driven by triggers based on a specific rules/policies. A write up on scaling the SQL Databases is @ https://www.sqlshack.com/azure-automation-automatic-scaling-azure-sql-databases-based-on-cpu-usage-threshold/
Its also worth noting the key characteristics of the business tier:
-Designed for business applications with highest performance and HA requirements
-Comes with super-fast local SSD storage (up to 1 TB on Gen4 and up to 4 TB on Gen5)
-Built-in high availability based on Always On availability groups and Azure Service Fabric
-Built-in additional read-only database replica that can be used for reporting and other read-only workloads
-In-Memory OLTP that can be used for workload with high-performance requirements There is no direct auto-scaling of the Azure SQL Managed Instance. For auto-scaling the Azure SQL Managed Instance you can try using PowerShell. Check the below resources for more info
Track progress of SQL Managed Instance create/scale request
Modify Azure SQL Database Managed Instance using Azure CLI
You can also use automation runbooks as mentioned here:
Auto Scaling Azure SQL DB using Automation runbooks
Just be careful, cause this might cause downtime or tasks to be cancelled.
