Veljko Vasic explains how Azure SQL Database uses built-in intelligence to continuously monitors database usage so that it can detect disruptive events that cause poor performance.
Once detected, a detailed analysis is performed generating a diagnostic log with an intelligent assessment of the issue, which consists of a root cause analysis of the database performance issue and recommendations for performance improvements where possible (i.e., intelligent insights).
For more information, see:
- Monitor Database Usage with Intelligent Insights
- Monitor Azure SQL Database using Azure SQL Analytics (Preview) in Log Analytics