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.