Azure Monitor and Azure SQL Database

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.

telemtry

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.whereto

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.

LOGS111

The below message is quite common, so be patient.

nologs

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

AzureDiagnostics

| summarize countLogsPerCategory=count() by Category

| sort by countLogsPerCategory

 

1 thought on “Azure Monitor and Azure SQL Database

  1. Pingback: Dew Drop – June 10, 2020 (#3215) | Morning Dew

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s