Monitoring Azure SQL Database or Managed Instance in Checkmk

General
1

I have been working on integrating Azure SQL Database and Azure SQL Managed Instance monitoring with Checkmk. I wanted to ask if anyone here has done something similar and what approach worked best for you. From what I have seen, Azure SQL Database metrics can be pulled through the standard Azure integration in Checkmk. But the Managed Instance side seems to behave a bit differently. It exposes metrics more like a full SQL Server, so I am wondering if anyone has tried using MSSQL checks or a hybrid setup.

I also noticed some Microsoft Azure Data Fundamentals Exam Discussions on Pass4Future explored Azure monitoring questions and shared examples of using both Azure Monitor APIs and SQL checks together. That made me think a combined method might give better visibility, especially for performance counters and query statistics.

Has anyone tested this type of setup? Did you face any challenges with authentication or metric availability when using the Azure connector for MI?

2

The Azure integration already provides the relevant metrics via the special agent.
But you can also use mk-sql agent plugin to directly query the MSSQL instance either remote or local depending on if this instance is attached to a VM or not.