High Re-Compilations Per Second
High Re-Compilations per Second
According to sp_BlitzFirst®‘s diagnostics, your SQL Server is having to re-compile more than 10% of the incoming T-SQL requests. This is different from a high number of compilations – this means that SQL Server actually does have an execution plan in memory, but things have changed about the underlying objects, so the plans have to be recompiled.
To improve performance, ask these questions:
Did we recently rebuild indexes or update statistics on frequently-queried tables?
Are we constantly changing more than >20% of the data in a frequently-accessed table?
For personalized help with getting the right answers for your server, we’ve got SQL Critical Care®.