Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
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