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:
Management operations are the area of constant improvements. All improvements are part of one of the following groups:
SQL Managed Instance supports wide range of tools available for its management including ARM templates, Azure Portal, PowerShell commands, CLI commands, API definitions. Index of available commands can be found as part of the Managed API reference for Azure SQL Managed Instance together with quickstart content that will help you to quickly get your first managed instance.
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!
Call to action: Nominate the topics for upcoming blog posts using comment section and votes, or writing directly to email@example.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.