2.3 Tracking Even More Plan Cache Details with Query Store

The method of logging sp_BlitzFirst/Cache/Who to table will probably give you everything you need to troubleshoot the majority of parameter sniffing situations. However, sometimes you need to gather even more data, and you’re willing to pay a performance price to get it. Query Store is a built-in feature that can track dramatically more of the…

The method of logging sp_BlitzFirst/Cache/Who to table will probably give you everything you need to troubleshoot the majority of parameter sniffing situations. However, sometimes you need to gather even more data, and you’re willing to pay a performance price to get it. Query Store is a built-in feature that can track dramatically more of the...