Detectable types of query performance bottlenecks

Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
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

Related content

More resources for Azure SQL Database:

• Configure the max degree of parallelism (MAXDOP) in Azure SQL Database
• Understand and resolve blocking problems
• Diagnose and troubleshoot high CPU on Azure SQL Database and SQL database in Microsoft Fabric
• Monitor and performance tuning in Azure SQL Database and Azure SQL Managed Instance
• Monitor 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
• sys.server_resource_stats (Azure SQL Managed Instance)
• Overview of Azure SQL Managed Instance resource limits