Can I Manually Load SQL 2005 Execution Plans into Cache at Server Startup?
Posted on 2010-09-02
Every time I restart our main production SQL Server, performance sucks for a couple of days until the statistics and the execution plans are gradually compiled and loaded into cache. Since these are stored in volatile memory, they go away whenever the SQL Server Service is shut down.
What I want to do:
I want to be able to take the saved output from ShowPlan XML and load into the Server cache at startup, so I don't have to wait for all of the plans to be recompiled. I know that this can be done in Oracle. Can it be done in SQL Server 2005, and if so, how?