Query Store Defaults in Azure SQL Database For more information, see Azure SQL Database Query Performance Insight. While you can use Management Studio and Azure Data Studio to get detailed resource consumption for all your queries, such as CPU, memory, and I/O, Query Performance Insight gives you a quick and efficient way to determine their impact on overall DTU consumption for your database. If you run Query Store in Azure SQL Database, you can use Query Performance Insight to analyze resource consumption over time. Use Query Performance Insight in Azure SQL Database Download the latest version of Management Studio here.įor a quick description on how to use Query Store in troubleshooting scenarios, see Query Store Azure blogs. SQL Server Management Studio has a set of user interfaces designed for configuring Query Store and for consuming collected data about your workload. Use the latest SQL Server Management Studio In Azure Synapse Analytics, configuration options for Query Store are not supported.