dbachecks
dbachecks copied to clipboard
Add checks for Query Store Best Practices
New Check
What would you like to check?
Query Store Best Practices - output of Test-DbaDbQueryStore
What should be configurable for the results of the check ?
- Defaults should be from Test-DbaDbQueryStore
- Could add skip configs so you can control which BPs apply
- Could also have configs for the values - in Erin's post she mentions some reasons to change from best practices
What should be able to be excluded from being tested ?
- skip databases that you don't want QS configured on