SQL SERVER – Reducing TempDB Recompilation with Fixed Plan


 

Recently, I had a very interesting situation while working with my client on the Comprehensive Database Performance Health Check. Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan.

Real-World Scenario

One of the largest E-Commerce company recently reached out to me with help with their SQL Server Performance Tuning. We went ahead with a systematic and scientific way to look for the in-efficiency in the code. After spending a couple of hours we were able to list all the inefficiencies and implement their solutions.

However, when we were looking at the queries, we found an excessive amount of