Analyzing diagnostic logs using Azure SQL Analytics

Azure SQL Analytics (which is in preview at the time of writing this book) is a cloud monitoring solution that can be used to monitor one or more Azure SQL Databases, SQL Managed Instances, or elastic database pools. This solution shares the same method of configuration for both SQL Database and SQL Managed Instance, so all the activities will be concerned with Azure SQL Database only.

Azure SQL Analytics analyses diagnostics data that was logged by enabling the diagnostic settings (as discussed previously in the Diagnostic Settings and Logs section) to provide insights into things such as blocks, resource limits, deadlocks, wait stats, and timeouts. Moreover, custom monitoring rules and alerts can also be set up to enhance existing monitoring capabilities.

Azure SQL Analytics uses diagnostic logs for Azure SQL Database. Therefore, the first step is to enable diagnostic logs to send the logs to the Log Analytics workspace.

...