We are starting a series of article dedicated to #sqlmiops – an area that will consolidate all aspects of SQL managed instance management into one place.
One of the first things that customers face with each resource is resource creation. Creating a resource is part of the CRUD (Create+Read+Update+Delete) set of commands. In Azure SQL Managed Instance this set of commands is put under the umbrella of management operations (#sqlmiops). All management operations can be categorized as follows:
Instance deployment (new instance creation)
Instance update (changing instance properties, such as CPU or reserved storage)
Management operations are the area of constant improvements. All improvements are part of one of the following groups:
A thing that people pay attention to are the durations of the management operations. The timings and the overall expected durations are documented on the management operations overview page and are result of the connectivity architecture that is dedicated to the highest standard of security and the consistency even with such complex systems.
At high level, to support deployments within Azure virtual networks and provide isolation and security for customers, SQL Managed Instance relies on virtual clusters. The virtual cluster represents a dedicated set of isolated virtual machines deployed inside the customer's virtual network subnet.
When it comes to the monitoring, there are couple of options available for monitoring the management operations. In September 2020 new API for tracking the progress of operations was announced. This API can come handy if you are not using ARM templates but have dependent actions that should be taken depending on the progress of managed instance operation. Usually, when virtual cluster step is completed, you are close to get your instance deployed and you can start with spinning up dependent resources like app environments, VMs that will be used to manage the SQL server or similar.
Product group continues investment in the #sqlmiops space, and new interesting staff is coming soon. Stay tuned with #sqlmiops!