Category: Query Store

Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database.
Erin Stellato shows how to use Query Store to troubleshoot wait statistics in SQL Server 2017 and Azure SQL Database.
November 27, 2017 | SQLPerformance.com | Query Store, Wait Stats 0
Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.
Benjamin Nevarez gives a very early look at a feature coming soon to Azure SQL Database and SQL Server vNext: the Query Store.

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More