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
Edit: November 12, 2020 – Updated information about Query Store performance overhead can be found in this post. “What is the performance overhead of enabling
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
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.