Detectable types of query performance bottlenecks

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

This content is split into two articles:

• Detectable types of query performance bottlenecks in Azure SQL Database
• Detectable types of query performance bottlenecks in SQL Server and Azure SQL Managed Instance

Next steps

More resources for Azure SQL Database:

• Configure the max degree of parallelism (MAXDOP) in Azure SQL Database
• Understand and resolve Azure SQL Database blocking problems in Azure SQL Database
• Diagnose and troubleshoot high CPU on Azure SQL Database
• SQL Database monitoring and tuning overview
• Monitoring Microsoft Azure SQL Database performance using dynamic management views
• Tune nonclustered indexes with missing index suggestions
• Resource management in Azure SQL Database
• Resource limits for single databases using the vCore purchasing model
• Resource limits for elastic pools using the vCore purchasing model
• Resource limits for single databases using the DTU purchasing model
• Resource limits for elastic pools using the DTU purchasing model

More resources for SQL Server and Azure SQL Managed Instance:

• Configure the max degree of parallelism Server Configuration Option
• Understand and resolve SQL Server blocking problems
• Monitoring Microsoft Azure SQL Managed Instance performance using dynamic management views
• Tune nonclustered indexes with missing index suggestions
• sys.server_resource_stats (Azure SQL Managed Instance)
• Overview of Azure SQL Managed Instance resource limits