Monitoring MS SQL Databases with Azure SQL Analytics in Log Analytics workspace

Azure SQL Analytic allow us to see Azure SQL DBs logs in one place, in this solution we can monitor such as

• SQL Databases
• SQL Managed instances
• SQL Elastic pools

This dashboard shows us such as deadlock, slow queries, SQL query performances.

Enabling this solution quite easy first we need to find or create a workspace and add AzureSQLAnalytic dashboard.

Than adding Azure SQL Analytic solution from market place.

This solution must appear on the workspace

When SQL diagnostic logs send to this workspace should be visible here.

Sending SQL Logs to workspace

Adding SQL Databases to diagnostic logs

Adding SQL elastic pool to diagnostic logs

Selected metrics will be send to selected Log Analytics dashboard

After logs send to Log Analytics, witch databases and instances sending logs are visible on the dashboard.

Inside the dashboards