A monitoring and analysis capability, built into Azure SQL Database and available through third-party tools for on-premises SQL Server, that identifies top resource-consuming queries, their execution patterns, and performance trends over time.
- Query analysis: Query Performance Insight aggregates query execution metrics such as CPU usage, duration, I/O, and memory consumption over defined time periods, helping DBAs identify the queries responsible for the highest resource utilization.
- Azure SQL Database integration: In Azure SQL Database, Query Performance Insight is built into the Azure portal, displaying historical trends and highlighting top queries by CPU usage, execution duration, and execution count.
- On-premises SQL Server: Similar query performance insights are available for on-premises SQL Server through Query Store reports in SQL Server Management Studio (SSMS) or by using dedicated SQL Server monitoring solutions.
- Performance optimization: DBAs use Query Performance Insight to prioritize tuning efforts by focusing on the queries that have the greatest impact on overall server performance and resource consumption.
- Relevant Idera tools: SQL Diagnostic Manager provides comprehensive query performance analysis across on-premises, cloud, and hybrid SQL Server environments from a single monitoring platform.
- Related terms: Query Store, Execution Plan, Root Cause Analysis, Azure SQL Database.
