Important Query Store Fixes – January 2019
The latest CUs for SQL Server 2016 and 2017 contain some important Query Store fixes that I thought worth mentioning for those of you on
Menu
The latest CUs for SQL Server 2016 and 2017 contain some important Query Store fixes that I thought worth mentioning for those of you on
I recently booked my flight to the U.K. for SQLBits, and I realized I probably should write a post about my full day training session
Last week there was a question on #sqlhelp on Twitter about the status of Query Store for a database in an Availability Group. I’ve written
Query Store retains query performance data at the plan level. This data is then broken out into intervals of time, determined by the INTERVAL_LENGTH_MINUTES setting.
This post, Finding the Slowest Query in a Stored Procedure, originally appeared on the PASS website. It has been re-posted here with permission. Figuring out
Edit: November 12, 2020 – Updated information about Query Store performance overhead can be found in this post. “What is the performance overhead of enabling
Last week I got an email from a community member who had read this older article of mine on baselining, and asked if there were
I recently had a scenario in a two-node Availability Group where multiple large-batch modification queries were executed and created a large redo queue on the
Last month I was in Portugal for their SQLSaturday event, and I spent a lot of time talking about Plan Forcing in SQL Server –
If you are trying to execute an ALTER DATABASE command to change a Query Store option (e.g. turn it off, change a setting) and it
I am so excited to announce that I am presenting a full day of Query Store Training, in-person, this September in Lisbon, Portugal! The SQLskills
Last week I presented a session on Query Store and when talking about the settings I mentioned that monitoring space used by Query Store is
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.