Azure SQL Database and Azure SQL Managed Instance 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

Learn

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

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 using AI

Concept

• 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