Azure SQL Database

Azure SQL Database is an always-up-to-date, fully managed relational database service built for the cloud. With Observe’s SQL Database integration, you can gain valuable insights into your databases’ performance. You can monitor one or more SQL databases with the SQL Database app.

Installed Datasets

  • SQL Database

  • SQL Database Audit Logs

  • SQL Database Deadlocks

  • SQL Database Error Logs

  • SQL Database Logs

  • SQL Database Metrics

  • SQL Database Query Logs

  • SQL Database Query Store Runtime Metrics

  • SQL Database Timeouts

  • SQL Database Wait Statistics

  • SQL Server

Azure SQL Database Monitor Templates

  • SQL Database Serverless Memory less than 20% - This monitor alerts if memory drops below a given threshold for any serverless SQL database.

  • SQL Database Storage Space Used greater than 80% - This monitor alerts, if storage space used exceeds a given threshold (default 80%).

  • SQL Database Serverless CPU Threshold - This monitor alerts on CPU usage above a given threshold for any serverless SQL Database.

  • SQL Database CPU Threshold - This monitor alerts on CPU usage above a given threshold.

Viewing an Azure SQL Database in Observe

The SQL Databases Monitoring dashboard, included in the SQL Database resource dataset, helps you answer the following questions:

  • What resources are my databases using (CPU, memory, storage)?

  • How many workers are my databases using?

  • Do my SQL Databases have any timeouts or deadlocks?

  • How long is my average query duration?

Monitoring dashboard for an Azure SQL Database

Figure 1 - The Monitoring dashboard for SQL Databases

Once you’ve found a database of interest, you can click on the name of the database, and click Open from the right menu. This takes you to the SQL Database Monitoring dashboard for that database. This dashboard includes more detailed information including:

  • Database Connections

  • More detailed resource usage

  • A table of queries sorted by query length to troubleshoot slow queries

Instance Monitoring dashboard for SQL Database

Figure 2 - The instance Monitoring dashboard for SQL Database

The instance dashboard also includes a Metrics Explorer dashboard that allows you to explore any metric that applies to your database.

Metric Explorer in the Instance Monitoring dashboard for SQL Database

Figure 3 - The Metric Explorer in the Instance Monitoring dashboard for SQL Database

Installing the Azure SQL Database App

To install the Azure SQL Database app, see Microsoft Azure Setup.

Azure SQL Database Metrics

To learn more about Azure SQL Database Metrics, see Monitoring and performance tuning in Azure SQL Database and Azure SQL Managed Instance.