Query Tuning Week: How to Run sp_BlitzCache on a Single Query

Geschrieben von Database Magician am Montag, 22. August 2016

'The most popular way of using sp_BlitzCache® is to just run it – by default, it shows you the top 10 most CPU-intensive queries that have run on your server recently. Plus, it shows you warnings about each of the queries – if they’re missing indexes, experiencing parameter sniffing issues, running long, running frequently, doing implicit conversion, you name it.

But sometimes you just want to see the warnings for a query you’re working on – and the query isn’t in your top 10 most resource-intensive queries.'...

https://www.brentozar.com/archive/2016/08/run-sp_blitzcache-single-query/?utm_source=Brent+Ozar+Unlimited®+List&utm_campaign=aa2f9d002c-RSS_EMAIL_CAMPAIGN&utm_medium=email&utm_term=0_8e3e861dd9-aa2f9d002c-296247489