Scaling a managed instance

SQL Managed Instance gives us the flexibility to dynamically scale up or down instance resources as and when required. You can scale up instance resources whenever there is peak demand and scale down the resources whenever the demand ends. This can help in effectively managing costs for SQL Managed Instance. In previous chapters, we learned about different purchasing options and service tiers for SQL Managed Instance and we also saw how single managed instances are hosted inside a virtual cluster.

SQL Managed Instance provides management operations, and they can be used to deploy a new managed instance, updating existing instance properties and deleting the instance when it's not required. Here, we will be learning about SQL Managed Instance scaling management operations and how they impact the virtual cluster. The duration of these scale-up/down requests depends on virtual cluster operations. Adding additional virtual machines to a virtual cluster...