Preview: Azure SQL Database Query Store

quinta-feira, 28 de maio de 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.

Conta gratuita

Aprenda e crie com $200 de crédito e continue gratuitamente

Início gratuito

Visual Studio

Assinantes ganham até $1800 por ano de serviços do Azure

Ative Agora

Inicializações

Participe do programa BizSpark e obtenha serviços gratuitos do Azure

Saiba mais