dbachecks icon indicating copy to clipboard operation
dbachecks copied to clipboard

Add checks for Query Store Best Practices

Open jpomfret opened this issue 5 years ago • 0 comments

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

jpomfret avatar Nov 24 '20 18:11 jpomfret