While under the covers an Azure SQL Database or Azure Managed Instance, at their core, are just versions of SQL Server, the details of the unique implementation requires a unique monitoring solution.
SQL Monitor is built to provide a monitoring for your Azure Databases. This ensures that you have the same kind of knowledge and management abilities within Azure that you’re used to with on-premises SQL Server instances.
As you begin the process of moving your data management to Azure SQL Databases, you’ll quickly realize that you need to monitor those servers much the same way as you do other instances of SQL Server.
While the Azure portal offers ways to build out a dashboard manually to achieve this, that does entail quite a bit of work and knowledge on your part. Further, while it will make it so you can see your Azure resources, it doesn’t monitor your local instances of SQL Server. In order to both keep an eye on your Azure resources and your local resources, you’re going to want to use a tool like Redgate SQL Monitor.
SQL Monitor is built to monitor SQL Server instances and databases, but it also has direct support for Azure SQL Databases. This means that traditional monitoring that you need within Azure SQL Database such as blocking, deadlocks, and query behaviors are included. However, SQL Monitor also includes the unique elements that Azure SQL introduces such as tracking vCore or DTU use. This means that you get both kinds of monitoring in a well defined user interface.
Whether you’re using Managed Instances, Azure SQL Database databases, Elastic Pools, or any of the other Azure offerings, SQL Monitor is ready to use to keep track of the overall health of your Azure Servers. For more detail on exactly how SQL Monitor works with Azure, you can read this article.
Redgate has been working within Azure for a very long time. That knowledge and experience are built into SQL Monitor. However, we also have additional resources from lessons at Redgate University, to articles on our Learning Hub, to webinars from our Product Advocates. We can help you transition to Azure as well as use our tools effectively there.
|Global Overview – See all your Azure resources in one place|
While working with Azure SQL Database and Managed Instance, you may have lots of different databases supporting your infrastructure. Using SQL Monitor lets you see all those different databases in a single place in order to more quickly understand that current status of your enterprise.
|Diagnosis - Azure specific knowledge to assist troubleshooting|
Whether you’re using DTU or vCPU, or you have your databases in a Pool, SQL Monitor has the built-in monitoring metrics unique to Azure in order to support your understanding of the behavior of your systems.
|Alerting - Immediate information about your Azure databases|
SQL Monitor includes built-in alerts specific to Azure databases so you can immediately know if there’s an issue. Further, many of the standard alerts are immediately applicable to Azure SQL Database. Finally, you can create customized alerts, as well as customize the existing alert thresholds, in order to make the system work the way you need it.
|Query impact – Finding and fixing bad query performance in order to reduce Azure costs|
One of the biggest problems within Azure SQL Database is how bad code, poor indexing, or out of date statistics can lead to not only bad performance, but increased costs. SQL Monitor can quickly identify poorly performing queries, excessive waits, and guide you in possible solutions in order to help you reduce your Azure costs.
|Hybrid Monitoring – Your Azure databases and your local instances in one pane of glass|
Since SQL Monitor works with both on-premises SQL Server instances and your cloud-based Azure databases, your hybrid environment is supported, day one. A single pane of glass lets you see your estate, regardless of where the database lives.