Azure SQL Managed Instances Real time Monitoring & Alerting

Question

I am looking for recommendation for real time monitoring and alerting solution for Azure SQL Managed instances.

As per my research we can use:

1. Azure Monitor: We can use it for basic telemetry monitoring like read/write operation, CPU etc. Azure monitor log ingestion could have latency >2 minute so its not actually real time monitoring.
2. Azure SQL Analytics: This solution is currently in preview. It provides more insight in Azure SQL Managed instance performance monitoring but its not real time and can have latency of ~10 mins. So it will not fit for real time monitoring and alerting.

I believe there are some 3rd party solutions available as well. Appreciate if you can share your recommendations and experiences using any solution for monitoring and alerting in real time for Azure SQL Managed Instances.

Answer 1

@AzDev - Thank you for reaching out on Microsoft Q&A Platform.

Updating the information here from comments for broader community usage.

In general number of options do exist for monitoring and alerting of managed instances that can be considered, be it Microsoft cloud native, on-premises products, custom solutions or third party solutions. If you haven't already reviewed , please refer to this blog which summarizes options available to monitor managed instance resources and performance. However the list gets shortened if you are looking for real time and not near real time( example 1 min sampling frequency) doesn't fit your requirement.

Please note that products and options listed in the article, might have additional features added over course of time , request to please research for specific tools accordingly.

Hope this information helps. Please feel free to revert back if you have any further queries. Thank you