Azure SQL monitoring and performance tuning

Azure SQL Database and Azure SQL Managed Instance provide tools to help you collect metrics and diagnostic information to monitor your database and improve its performance.

Get started with monitoring and performance tuning

Overview

• Monitoring and performance tuning

Training

• Configure databases for performance
• Optimize query performance
• Monitor and optimize operational resources
• Protect, monitor, and tune

Database watcher for Azure SQL

Concept

• Monitor Azure SQL workloads with database watcher
• Manage and monitor database watchers
• Database watcher FAQ

How-To Guide

• Create a database watcher to monitor Azure SQL

Azure Monitor and Azure SQL Database

How-To Guide

• Monitor Azure SQL Database with metrics and alerts

Concept

• Monitor Azure SQL Database with Azure Monitor

Azure SQL Database intelligent performance recommendations

Concept

• SQL Database Advisor tuning recommendations
• Automatic tuning
• Query Performance Insight

Azure SQL Database and Azure SQL Managed Instance resource limits

Concept

• Single database vCore resource limits
• Single database DTU resource limits
• Elastic pool vCore resource limits
• Elastic pool DTU resource limits
• SQL Managed Instance resource limits
• Instance pools resource limits

Intelligent performance analysis for Azure SQL Database and Azure SQL Managed Instance

Overview

• Intelligent Insights

Concept

• Metrics and alerts
• Metrics and diagnostics logging
• Understand the performance diagnostics log
• Azure SQL Analytics
• Detectable performance patterns
• Intelligent query processing

Manual performance tuning for Azure SQL Database and Azure SQL Managed Instance

Overview

• Identify query performance issues

Concept

• Monitoring using DMVs
• Application and database tuning
• Using Query Store
• Using extended events
• Hyperscale performance diagnostics

Azure SQL Database and Azure SQL Managed Instance resource scaling

Overview

• Dynamically scaling resources

Concept

• Scaling single database resources
• Scaling elastic pool resources
• Scaling managed instance resources
• Read scale-out