Is your feature request related to a problem? Please describe.
This is absolutely something that I would use. I frequently use Query Store to check how my instance/database/query has changed since I made a change. This kind of A-B testing is even one of the suggested use cases for Query Store and there are twoexamples in the official docs and one dashboard in SSMS for it. Microsoft clearly want you to use Query Store for this and there is no greater pleasure than turning this data in to an argument-winning slideshow. Given that Erik is a consultant himself, I'm sure that he knows this very well... Along with the copy and pasting to Excel that it brings.
To my knowledge, sp_QuickieStore does not support this at all. If I want to use sp_QuickieStore to find queries that have recently changed in performance, I have to conduct awful hack like this:
Make a note of when I made the change that I want data about.
Search sys.query_store_plan for any queries that have at least two plans and have one that compiled after I made that change. Be super careful with what time I'm using for initial_compile_start_time because it doesn't handle UTC as gracefully as sp_QuickieStore.
Use STRING_AGG to turn the query_ids in to a comma separated list.
Call sp_QuickieStore with my STRING_AGG list as the @include_query_ids parameter and @start_date at the earliest point in time that I want to compare my new data against.
Describe the solution you'd like
Somehow, make sp_QuickieStore able to find queries that have changed in performance since a particular point in time. If I can hack it in and Microsoft can do it from the Query Store DMVs, then there must be a way to build in to to sp_QuickieStore.
Describe alternatives you've considered
Continue using my hacks, but beg for them to be added to the examples file.
Are you ready to build the code for the feature?
Yes... But it wouldn't be quick. I think I'd have to properly go line-by-line through sp_QuickieStore and really learn how it works before I can develop this one.
Is your feature request related to a problem? Please describe. This is absolutely something that I would use. I frequently use Query Store to check how my instance/database/query has changed since I made a change. This kind of A-B testing is even one of the suggested use cases for Query Store and there are two examples in the official docs and one dashboard in SSMS for it. Microsoft clearly want you to use Query Store for this and there is no greater pleasure than turning this data in to an argument-winning slideshow. Given that Erik is a consultant himself, I'm sure that he knows this very well... Along with the copy and pasting to Excel that it brings.
To my knowledge,
sp_QuickieStoredoes not support this at all. If I want to usesp_QuickieStoreto find queries that have recently changed in performance, I have to conduct awful hack like this:sys.query_store_planfor any queries that have at least two plans and have one that compiled after I made that change. Be super careful with what time I'm using forinitial_compile_start_timebecause it doesn't handle UTC as gracefully assp_QuickieStore.STRING_AGGto turn thequery_ids in to a comma separated list.sp_QuickieStorewith mySTRING_AGGlist as the@include_query_idsparameter and@start_dateat the earliest point in time that I want to compare my new data against.Describe the solution you'd like Somehow, make
sp_QuickieStoreable to find queries that have changed in performance since a particular point in time. If I can hack it in and Microsoft can do it from the Query Store DMVs, then there must be a way to build in to tosp_QuickieStore.Describe alternatives you've considered Continue using my hacks, but beg for them to be added to the examples file.
Are you ready to build the code for the feature? Yes... But it wouldn't be quick. I think I'd have to properly go line-by-line through
sp_QuickieStoreand really learn how it works before I can develop this one.IMPORTANT: If you're going to contribute code, please read the contributing guide first. https://github.com/erikdarlingdata/DarlingData/blob/main/CONTRIBUTING.md Absolutely yes.