8 March 2018
8 March 2018

Redgate’s support for Azure SQL Database Managed Instances

Today Microsoft released the public preview of Azure SQL Database Managed Instances – an exciting new option for running SQL Server workloads in the cloud. I’m pleased to say that initial support for this new offering is already available across the development tools in Redgate’s SQL Toolbelt, as well as in SQL Monitor. This support will continue to improve as the platform evolves throughout its public preview.

What are Managed Instances?

Managed Instances (or Azure SQL Database Managed Instances, to give them the long name) are a new PaaS database offering, joining the Azure SQL Database and Elastic Pool services. As part of this PaaS family, Managed Instances take care of many operational aspects like ensuring high availability, backups, and applying patches, making them simpler and less time-consuming to administer.

While many organizations have benefited from using Azure SQL Database for new applications, it has been a significant challenge to migrate existing workloads because of key functionality gaps versus on-premises SQL Server.

Managed Instances squarely address that problem, providing vastly improved compatibility. Organizations can therefore easily migrate existing on-premises SQL Server workloads to the cloud while retaining many of the manageability benefits of a PaaS offering.

Redgate’s relationship with Microsoft has enabled us to be part of the private preview program for Managed Instances over the last few months, so we’re pleased to be able to provide support from day one.

Special considerations for monitoring

While Managed Instances will require less operational oversight compared to traditional on-premises SQL Server, many responsibilities for the DBA will remain. For example, using the service doesn’t free you from the responsibility for checking availability or ensuring that security is configured appropriately. It also remains your responsibility to optimize performance, and handle other operational concerns like making sure jobs complete successfully and general troubleshooting.

In the medium term, organizations migrating on-premises workloads to Managed Instances are likely to be running a combination of Managed Instances and on-premises SQL Server, so monitoring both seamlessly as part of a single SQL Server estate is important. SQL Monitor lets you achieve this.

One point to note about Managed Instances is that by design they don’t expose a direct public endpoint – instead you must connect to the instance from within the same Virtual Network (VNET). Therefore there are three options for monitoring Managed Instances using SQL Monitor:

  1. Run SQL Monitor in your own datacenter (perhaps monitoring other SQL Server instances), and set up a site-to-site Virtual Private Network between your SQL Monitor installation and the VNET containing the Managed Instance.
  2. Run SQL Monitor on a VM in Azure, either on the same VNET as the Managed Instance, or on a different VNET but with direct connectivity setup between those two VNETs (for example, using peering).
  3. Run an existing SQL Monitor installation in your own datacenter, but create an additional SQL Monitor installation on an Azure VM in the same VNET as the Managed Instance. The new Distributed Monitoring capabilities in SQL Monitor 8 allow your on-premises SQL Monitor installation to connect to the separate installation in Azure, and to consolidate the data up to a single user interface. Data from both SQL Monitor installations – whether looking at metric analysis, overviews, reporting, or viewing alerts – is all seamlessly integrated. This feels just like using a single installation, while providing the benefits of easier configuration.

Find out more about how SQL Monitor lets you proactively monitor your SQL Server estate, whether on-premises or in the cloud.

Tools in this post

SQL Monitor

SQL Monitor is a SQL server monitoring tool that transforms the way you look at your database. It cuts your daily check to minutes, with a web-based overview of all your SQL Servers.

Find out more

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

You may also like

  • Article

    SQL Server monitoring from the trenches: An interview with Anthony Nocentino

    I recently sat down with Enterprise Architect, Anthony Nocentino, to talk about how effective monitoring can help resolve many of the issues companies face every day. I was fascinated because my career revolves around how we can improve SQL Server monitoring. Anthony’s involves actually doing it at the coalface. He’s made a name for himself

  • Community event

    SQL Saturday Holland

    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Redgate are proud to be attending as a Gold sponsor, so stop by and meet the team. Admittance to this event is almost free, all costs are covered by donations and sponsorship except for a €15 lunch fee which

  • Article

    What you need to know about the State of SQL Server Monitoring 2019

    In 2018 we launched the industry’s first ever report into the state of SQL Server monitoring. The responses from over 600 SQL Server professionals gave us a unique insight into how they monitor their estates, the technologies they work with, and what were the biggest challenges they faced. In 2019 we ran our State of

  • Article

    Monitoring and Troubleshooting Deadlocks with SQL Monitor

    Tony Davis demonstrates a deadlock incident, as detected in SQL Monitor, and shows how we can find the cause quickly, using the Extended Events deadlock graph provided in the alert details, plus details of the sessions and queries that were running at the time it occurred.