HomeAzure SQL DatabasePublic preview of Azure SQL Database Managed Instance

Comments

Public preview of Azure SQL Database Managed Instance — 5 Comments

  1. “Lift and shift”, LOL. OK fine. I wonder why it’s taken so long. For that matter, I wonder why they didn’t do it this way the first time around. I don’t see pricing information.

  2. I am a little unclear about this; is it effectively a VM Sql managed by Microsoft instead of having to do it manually. I ask because it’s priced on vcores instead of those impossible to predict DTUs.

    I have tried SQL Azure Database but it’s way to slow even on the most premium of plans for me to use and then costs 1000’s a month … slow AND ridiculously expensive. So I have had to use an Azure VM with SQL Server. However, it’s a pain to have to manage updates and so on on the VM, and I don’t get benefit of redundancy or failover etc with a huge amount of config and extra vms and complexity which I don’t have knowledge or experience of.

    This sql managed instance seems a better fit for my app, but only if it isn’t as slow as sql azure and more akin to a VM?

    Could you help me out with a more fundamental explanation of what it is and what it’s difference is to Sql Azure and a VM.

    • Hi Dan,

      Think of Managed Instance as Azure SQL Database on steroids. It has all the benefits of Azure SQL Database (i.e. built-in disaster recovery, no VMs to manage, etc) while removing almost all the limitations of Azure SQL Database (i.e. cross-database queries, SQL Agent). It is not IaaS, it is PaaS. They switched to vcores instead of DTUs because of the difficulty in predicting performance as you mentioned. It will have much better performance that “regular” Azure SQL Database so give it a chance 🙂

  3. Pingback:Public preview of Azure SQL Database Managed Instance - SSWUG.ORG

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>