Azure SQL Database built-in intelligence will continuously monitor database usage, detect disruptive events that can cause poor performance, and generate an intelligent insights diagnostic log. The insights provided will consist of a root cause description of performance degradation and improvement recommendations where possible. You will be able to couple this feature with Azure Log Analytics, or a third-party solution for custom alerting and reporting capabilities.
Learn more.