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