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, The Team Membership, Mastering Query Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.