As you could see on previous post (AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #1) using Azure SQL DB + Log Analytics is quite easy. Let see how can we improve even further with ALERTS
As a DBA you may want to query SQL Audit and SQL Diagnostics information. The easiest way to do this is sending to Log analytics that is part of Azure Monitor You can also send this data to Event Hubs and storage accounts. On this post I will focus on Log Analytics
This is a copy of original post I wrote to Azure SQL DB Support blog. Also updated with some news in Azure Metrics https://blogs.msdn.microsoft.com/azuresqldbsupport/2019/02/08/how-to-get-azure-sql-database-size/ There are multiple ways to achieve this and there are also some storage types you should be aware
Sergio Fonseca Blog 