Database Startup Times

Have you have ever wondered what your database is doing as it starts and works through the various stages (including crash recovery) up to the point when it is open and available for user connections? Maybe your database seems to take a long time, but you know it was cleanly shutdown so the number of…


Query Store: How it works? How to use the new Query Store Catalog Views?

Part 2 /*Fix 2017.03.28: Not Query Store DMVs but Catalog Views. Thanks Kalen Delaney for point it*/ “The SQL Server Query Store feature provides you with insight on query plan choice and performance. It simplifies performance troubleshooting by helping you quickly find performance differences caused by query plan changes. “msdn. If you want to know,…


Deconstructing Extended Event XML

In a recent engagement, I had need of an Extended Event to gather range scans on my target instance. The overall premise was to determine which queries were driving the large number of range_scans being reported by a recent health check. The target instance was a SQL 2008 R2 SP3 build. So… lets create an…