SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period


 

One of the reasons, I love my job of SQL Server Performance Tuning Expert is that I get to learn every single day something new while working with my client on Comprehensive Database Performance Health Check. Recently I got a very unique situation where I had to Remove All Query Cached Plans Not Used In Certain Period. Let us learn about that today.

Story in Brief

During the consulting engagement, we scientifically and systematically worked on my client’s server and build an action plan which will improve their server’s performance by multiple times. Later on, we implemented all the suggestions one by