-
Notifications
You must be signed in to change notification settings - Fork 182
Description
Is your feature request related to a problem? Please describe.
sp_QuickieStore has served me very well. So well, that I've forgotten how to use the Query Store views. This made me rather shocked an hour or so ago when I discovered the documentation for sys.database_automatic_tuning_configurations and sp_configure_automatic_tuning. How could there possibly be Query Store views unknown to both myself and sp_QuickieStore?
Really, did anyone know about this? I can't remember seeing any documentation or announcement from Microsoft. I've never seen anyone blog about it either. Maybe learning all of my Query Store tricks on a 2019 instance was a mistake.
The gist of sp_configure_automatic_tuning is that you can turn off FORCE_LAST_GOOD_PLAN for certain Query IDs. If somebody has done that, then expert mode should tell me.
Describe the solution you'd like
sys.database_automatic_tuning_configurations should get its own output table in expert mode, like the other 2022 views do.
Describe alternatives you've considered
Ponder #483 aggressively.
Are you ready to build the code for the feature?
As much as we'd love to build everything that everyone wants for free, we need your help. Open source is built with your help and code. Are you ready to commit time to this project? Have you got existing code you can help contribute to solve the problem?
I'm ready, but I wouldn't be able to do it quickly. I discovered the feature within the last hour. I probably wouldn't do a great job of this.
IMPORTANT: If you're going to contribute code, please read the contributing guide first.
https://github.com/erikdarlingdata/DarlingData/blob/main/CONTRIBUTING.md
Sure, it's been a while.