Standard SQL Server tools like Activity Monitor can be frustrating and often don't provide a historical view of what happened an hour ago. sp_BlitzCache "spelunks" through your plan cache to find: SQL-Server-First-Responder-Kit/sp_BlitzCache.sql at dev

There are three primary ways to acquire the script depending on your environment:

For the absolute latest development version or to contribute, you can download individual files directly from the SQL-Server-First-Responder-Kit GitHub .

To download , the industry-standard tool for SQL Server plan cache analysis, you should navigate to the official Brent Ozar First Responder Kit . This free, open-source script is the primary solution for DBAs and developers needing to identify the most resource-intensive queries running on their server without the overhead of manual trace tools. How to Download and Install sp_BlitzCache

Visit BrentOzar.com and enter your email address to receive a direct link to the FirstResponderKit.zip . This package contains sp_BlitzCache.sql along with other diagnostic procedures like sp_Blitz and sp_BlitzFirst .

SQL-Server-First-Responder-Kit/sp_BlitzCache. sql at dev · BrentOzarULTD/SQL-Server-First-Responder-Kit · GitHub. Navigation Menu. Introducing sp_BlitzCache® - Brent Ozar Unlimited®

If you use the dbatools module , you can install it directly into your instance by running: Install-DbaFirstResponderKit -SqlInstance YourServerName -Database master . Why You Need sp_BlitzCache