While Query Store has been out for quite some time now, released in 2016, there’s still quite a lot of missing understanding of what Query Store can do for you, and, how it does it. I’ve put together a new presentation on the Query Store, “Using Query Store to Understand and Control Query Performance“, incorporating the latest stuff from 2022, but still showing you all the goods from 2016, for the PASS Data Community Summit.
Why Query Store
I’ve been in love with Query Store since it was released. If you look through my blog, I’ve been talking about Query Store a lot. I provided a little help to Tracy Boggiano on her book (yes, emphasis on hers, because it is, I just helped), Query Store for SQL Server 2019. I had another presentation on Query Store I used to give too. In short, I’ve been trying to share the word on Query Store since the beginning.
Yeah, when I want hardcore details on query behavior, I’m still going to put Extended Events to work. However, day-in, day-out, quick answers to core questions like, what did this query run like yesterday/an hour ago/last week, are so much more easily answered using Query Store.
Plus, because Query Store is enabled on a database-by-database basis, you get a lot of control over where it runs. This helps to ensure you’re being cautious about how monitoring affects your servers.
Add in all the cool, and I mean really cool, automatic tuning functionality introduced first in 2019, but greatly expanded on in 2022, most of which is predicated on having Query Store enabled. You’ve got a winning strategy with turning on Query Store.
So, if you’re attending PASS Data Community Summit, I’d sure love to see you in my session. If my passion for the topic isn’t enough, here’s a little more incentive. You can use ‘GFSUMMIT67’ to get $200 off the 3-day registration. Further, if you want to attend virtually, I can help there too. ‘GFONLINE67’ will get you 50% off the online registration. Go here to get registered.
Also, there are several other people who are talking about Query Store, or incorporating it into their talk. I’d strongly suggest checking them out as well.