Preview: Azure SQL Database Query Store

28 May 2015

Available in preview today, you can use Azure SQL Database Query Store. This feature enables you to easily identify queries that used to perform well but now perform poorly. It accumulates a history of each query, including its associated plans, run-time statistics, and information about resource consumption. Query Store separates collected data by time windows, allowing you to see changes in database utilization and performance over time. If a query generates a different plan, you can use Query Store to analyze the query plan changes, possible performance degradation, or even to force the system to use a particular plan for your query. Query Store is a database level feature. SQL Server Management Studio or another Transact-SQL delivery tool is required to implement and manage Query Store. For more information, visit the Query Store  page on MSDN.

Free account

Sign up now and get $200 in Azure credit

Start free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now

Startups

Join the BizSpark program and get free Azure services

Learn more