1.5 Using sp_BlitzCache to Find the Right (Wrong) Queries (43m)

In the open source First Responder Kit, sp_BlitzCache analyzes your plan cache to find the most resource-intensive queries. It analyzes their plans to point out issues like forced serialization, implicit conversion, expensive key lookups, and much more. We show how to use it – and how you’ll be using it in the next lab. Demo…

To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Query Tuning, or log in if you already shelled out the cash.