Azure SQL monitoring and performance tuning

Get started with monitoring and performance tuning

Overview

• Monitoring and performance tuning

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

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
• 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