| title | Types of query performance issues |
|---|---|
| titleSuffix | Azure SQL Database & Azure SQL Managed Instance & SQL Server |
| description | Learn about types of query performance issues, and how to identify and resolve queries with these issues. |
| author | NikaKinska |
| ms.author | nnikolic |
| ms.reviewer | mathoma, wiassaf |
| ms.date | 07/29/2022 |
| ms.service | sql-database |
| ms.subservice | performance |
| ms.topic | troubleshooting |
| monikerRange | =azuresql||=azuresql-db||=azuresql-mi |
[!INCLUDEappliesto-sqlserver-sqldb-sqlmi]
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