Azure SQL Managed Instance – introduction to #SQLMIOPS

Published Aug 26 2021 09:00 AM 1,647 Views
Microsoft

SQLMIOPS cover.pngWe 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)
  • Instance deletion

 

Management operations are the area of constant improvements. All improvements are part of one of the following groups:

  • Available tools
  • Duration
  • Monitoring

 

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.

 

connectivityarch002

 

 

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!

 

Announcements:

 

Azure SQL MI now removes virtual cluster as part of the delete flow

Azure SQL Managed Instance – Terraform command available

 

Call to action: Nominate the topics for upcoming blog posts using comment section and votes, or writing directly to  mdcssqlmipm@microsoft.com

2 Comments

Hi @UrosMilanovic , How can we get notified about the posts on #salmiops?

Microsoft

Hi @deivasigamani-duraisamy Unfortunately it is not possible to subscribe to tags. Subscribing to Azure SQL Managed Instance label seems as the closest solution.

%3CLINGO-SUB%20id%3D%22lingo-sub-2687265%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Managed%20Instance%20%E2%80%93%20introduction%20to%20%23SQLMIOPS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2687265%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22SQLMIOPS%20cover.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306228i306C43978AD35B89%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SQLMIOPS%20cover.png%22%20alt%3D%22SQLMIOPS%20cover.png%22%20%2F%3E%3C%2FSPAN%3EWe%20are%20starting%20a%20series%20of%20article%20dedicated%20to%20%23sqlmiops%20%E2%80%93%20an%20area%20that%20will%20consolidate%20all%20aspects%20of%20SQL%20managed%20instance%20management%20into%20one%20place.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20of%20the%20first%20things%20that%20customers%20face%20with%20each%20resource%20is%20resource%20creation.%20Creating%20a%20resource%20is%20part%20of%20the%20CRUD%20(Create%2BRead%2BUpdate%2BDelete)%20set%20of%20commands.%20In%20Azure%20SQL%20Managed%20Instance%20this%20set%20of%20commands%20is%20put%20under%20the%20umbrella%20of%20%3CA%20title%3D%22Azure%20SQL%20Managed%20Instance%20management%20operations%20overview%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fmanagement-operations-overview%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Emanagement%20operations%3C%2FA%3E%20(%23sqlmiops).%20All%20management%20operations%20can%20be%20categorized%20as%20follows%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EInstance%20deployment%20(new%20instance%20creation)%3C%2FLI%3E%0A%3CLI%3EInstance%20update%20(changing%20instance%20properties%2C%20such%20as%20CPU%20or%20reserved%20storage)%3C%2FLI%3E%0A%3CLI%3EInstance%20deletion%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EManagement%20operations%20are%20the%20area%20of%20constant%20improvements.%20All%20improvements%20are%20part%20of%20one%20of%20the%20following%20groups%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EAvailable%20tools%3C%2FLI%3E%0A%3CLI%3EDuration%3C%2FLI%3E%0A%3CLI%3EMonitoring%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESQL%20Managed%20Instance%20supports%20wide%20range%20of%20%3CSTRONG%3Etools%3C%2FSTRONG%3E%20available%20for%20its%20management%20including%20%3CA%20title%3D%22Create%20an%20Azure%20SQL%20Managed%20Instance%20using%20an%20ARM%20template%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fcreate-template-quickstart%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EARM%20templates%3C%2FA%3E%2C%20%3CA%20title%3D%22Create%20an%20Azure%20SQL%20Managed%20Instance%20using%20Azure%20Portal%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Finstance-create-quickstart%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Portal%3C%2FA%3E%2C%20%3CA%20title%3D%22PowerShell%3A%20Create%20and%20configure%20managed%20instances%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fapi-references-create-manage-instance%23powershell-create-and-configure-managed-instances%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EPowerShell%20commands%3C%2FA%3E%2C%20%3CA%20title%3D%22Azure%20CLI%3A%20Create%20and%20configure%20managed%20instances%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fapi-references-create-manage-instance%23azure-cli-create-and-configure-managed-instances%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECLI%20commands%3C%2FA%3E%2C%20%3CA%20title%3D%22REST%20API%3A%20Create%20and%20configure%20managed%20instances%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fapi-references-create-manage-instance%23rest-api-create-and-configure-managed-instances%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAPI%20definitions%3C%2FA%3E.%20Index%20of%20available%20commands%20can%20be%20found%20as%20part%20of%20the%20%3CA%20title%3D%22Managed%20API%20reference%20for%20Azure%20SQL%20Managed%20Instance%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fapi-references-create-manage-instance%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EManaged%20API%20reference%20for%20Azure%20SQL%20Managed%20Instance%3C%2FA%3E%20together%20with%20%3CA%20title%3D%22Getting%20started%20with%20Azure%20SQL%20Managed%20Instance%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fquickstart-content-reference-guide%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Equickstart%20content%3C%2FA%3E%20that%20will%20help%20you%20to%20quickly%20get%20your%20first%20managed%20instance.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA%20thing%20that%20people%20pay%20attention%20to%20are%20the%20durations%20of%20the%20management%20operations.%20The%20timings%20and%20the%20overall%20expected%20%3CSTRONG%3Edurations%3C%2FSTRONG%3E%20are%20documented%20on%20the%20%3CA%20title%3D%22Overview%20of%20Azure%20SQL%20Managed%20Instance%20management%20operations%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fmanagement-operations-overview%23duration%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Emanagement%20operations%20overview%20page%3C%2FA%3E%20and%20are%20result%20of%20the%20%3CA%20title%3D%22Connectivity%20architecture%20for%20Azure%20SQL%20Managed%20Instance%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fconnectivity-architecture-overview%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Econnectivity%20architecture%3C%2FA%3E%20that%20is%20dedicated%20to%20the%20highest%20standard%20of%20security%20and%20the%20consistency%20even%20with%20such%20complex%20systems.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22connectivityarch002%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F305999i5A388A8D02BFCFF4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22connectivityarch002%22%20alt%3D%22connectivityarch002%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAt%20high%20level%2C%20to%20support%20deployments%20within%20Azure%20virtual%20networks%20and%20provide%20isolation%20and%20security%20for%20customers%2C%20SQL%20Managed%20Instance%20relies%20on%20virtual%20clusters.%20The%20virtual%20cluster%20represents%20a%20dedicated%20set%20of%20isolated%20virtual%20machines%20deployed%20inside%20the%20customer's%20virtual%20network%20subnet.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20it%20comes%20to%20the%20%3CSTRONG%3Emonitoring%3C%2FSTRONG%3E%2C%20there%20are%20couple%20of%20%3CA%20title%3D%22Monitoring%20Azure%20SQL%20Managed%20Instance%20management%20operations%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fmanagement-operations-monitor%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eoptions%20available%20for%20monitoring%20the%20management%20operations%3C%2FA%3E.%20In%20September%202020%20new%20API%20for%20%3CA%20title%3D%22Track%20progress%20of%20SQL%20Managed%20Instance%20create%20and%20scale%20request%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sql%2Ftrack-progress-of-sql-managed-instance-create-scale-request%2Fba-p%2F1698640%22%20target%3D%22_self%22%3Etracking%20the%20progress%20of%20operations%3C%2FA%3E%20was%20announced.%20This%20API%20can%20come%20handy%20if%20you%20are%20not%20using%20ARM%20templates%20but%20have%20dependent%20actions%20that%20should%20be%20taken%20depending%20on%20the%20progress%20of%20managed%20instance%20operation.%20Usually%2C%20when%20virtual%20cluster%20step%20is%20completed%2C%20you%20are%20close%20to%20get%20your%20instance%20deployed%20and%20you%20can%20start%20with%20spinning%20up%20dependent%20resources%20like%20app%20environments%2C%20VMs%20that%20will%20be%20used%20to%20manage%20the%20SQL%20server%20or%20similar.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EProduct%20group%20continues%20investment%20in%20the%20%23sqlmiops%20space%2C%20and%20new%20interesting%20staff%20is%20coming%20soon.%20Stay%20tuned%20with%20%23sqlmiops!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-2119797807%22%20id%3D%22toc-hId-2119832435%22%20id%3D%22toc-hId-2119832435%22%20id%3D%22toc-hId-2119832435%22%20id%3D%22toc-hId-2119832435%22%20id%3D%22toc-hId-2119832435%22%20id%3D%22toc-hId-2119832435%22%20id%3D%22toc-hId-2119832435%22%3EAnnouncements%3A%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20title%3D%22Azure%20SQL%20MI%20now%20removes%20virtual%20cluster%20as%20part%20of%20the%20delete%20flow%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sql%2Fazure-sql-mi-now-removes-virtual-cluster-as-part-of-the-delete%2Fba-p%2F2703627%22%20target%3D%22_self%22%3EAzure%20SQL%20MI%20now%20removes%20virtual%20cluster%20as%20part%20of%20the%20delete%20flow%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ECall%20to%20action%3A%26nbsp%3B%3C%2FSTRONG%3ENominate%20the%20topics%20for%20upcoming%20blog%20posts%20using%20comment%20section%20and%20votes%2C%20or%20writing%20directly%20to%26nbsp%3B%20%3CA%20title%3D%22Azure%20SQL%20Managed%20Instance%20PM%20mail%20alias%22%20href%3D%22mailto%3Amdcssqlmipm%40microsoft.com%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Emdcssqlmipm%40microsoft.com%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2687265%22%20slang%3D%22en-US%22%3E%3CP%3EA%20series%20of%20article%20dedicated%20to%20%23sqlmiops%20%E2%80%93%20an%20area%20that%20will%20consolidate%20all%20aspects%20of%20instance%20management.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2687265%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Managed%20Instance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2710305%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Managed%20Instance%20%E2%80%93%20introduction%20to%20%23SQLMIOPS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2710305%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F496888%22%20target%3D%22_blank%22%3E%40UrosMilanovic%3C%2FA%3E%26nbsp%3B%2C%20How%20can%20we%20get%20notified%20about%20the%20posts%20on%20%23salmiops%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2749284%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Managed%20Instance%20%E2%80%93%20introduction%20to%20%23SQLMIOPS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2749284%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F785368%22%20target%3D%22_blank%22%3E%40deivasigamani-duraisamy%3C%2FA%3E%26nbsp%3BUnfortunately%20it%20is%20not%20possible%20to%20subscribe%20to%20tags.%20Subscribing%20to%20Azure%20SQL%20Managed%20Instance%20label%20seems%20as%20the%20closest%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Sep 14 2021 07:06 AM
Updated by: