This is all about enabling diagnostics telemetry for Azure SQL databases. For Azure SQL Database there are quite a few options to select from. Below shows the diagnostic settings available.
Once you click add, you will see that you can output the information to 3 locations. Storage account, log analytics or an event hub. I usually opt for log analytics.
If you go this route you must make sure that you have a log analytics workspace already created. Once you have selected the settings you want, go to the log analytics workspace within logs.
The below message is quite common, so be patient.
A New language is needed here. Called KQL – Kusto Query Language which basically is read only requests to process data. Not that I know much about it because I dont. Reminds me of SQL, hence the QL in KQL.
// Common categories in Azure diagnostics
// Count the number of logs reported per category
| summarize countLogsPerCategory=count() by Category
| sort by countLogsPerCategory