search

BrentOzarULTD / SQL-Server-First-Responder-Kit

sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
http://FirstResponderKit.org
Other
3.38k stars 999 forks source link

sp_Blitz: Added check for unusual Query Store query capture mode #3541

Closed ReeceGoding closed 5 months ago

ReeceGoding commented 5 months ago

Closes the last open item from #3527 .

I've made this a priority 200 issue under the 'Performance' header. This is the consistent with the check for having Query Store completely disabled. After all, the None mode isn't very different from that.

My claim that the All query capture mode can turn Query Store off is not in the URL provided. The documentation for that is actually here.

BrentOzar commented 5 months ago

Argh, this one can't be merged due to making too many changes in different PRs to the same area of code. I'm going to close this, but feel free to reopen it with a fixed version that'll merge.