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
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
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