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