Troubleshooting Variable Memory Grants in SQL Server Erin Stellato shares her approach to using Query Store to help troubleshoot performance issues involving memory grants. Erin Stellato ◆ June 5, 2019 1
Mining Plans : Not just for the plan cache Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database. Erin Stellato ◆ August 16, 2018 0
Wait Statistics and Query Store Erin Stellato shows how to use Query Store to troubleshoot wait statistics in SQL Server 2017 and Azure SQL Database. Erin Stellato ◆ November 27, 2017 3
Using DBCC CLONEDATABASE and Query Store for Testing Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes. Erin Stellato ◆ February 22, 2017 6
The SQL Server Query Store Benjamin Nevarez (@BenjaminNevarez) gives a very early look at a feature coming soon to Azure SQL Database and SQL Server vNext: the Query Store. Guest Posts ◆ February 19, 2015 10