Thursday, June 12, 2014

sp_BlitzCache™: finding the worst queries in SQL Server made easy…

I’m not a SQL Server expert, so any tool that can help me improve my data access strategy is welcome.

One of these tools that I found very useful is the sp_BlitzCache stored procedure created by Jeremiah Peschka. It analyzes the top poorly performing queries for many different problems giving you a nice and useful result set.

Just download the script and run it on your database server. This will install the sp_BlitzCache stored procedure, afterwards you can run it by calling EXEC sp_BlitzCache.

image

Download sp_BlitzCache now!

No comments: