1.5 Using sp_BlitzCache to Find the Right (Wrong) Queries

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, Live Class Season Pass PLUS Lab VM or Mastering Query Tuning, or log in if you already shelled out the cash.