Generate SP Execution Plan at server startup?

[sarah2michelle]

I have a SP that takes about 90 seconds longer to run the first time every time after a reboot, the performance is much better after that, until the next reboot. I am assuming this is because the execution plan is stored in memory after the first use. Is there a way to make SQL generate the execution plan at startup, or something like that so that it doesn't take the extra time the first time the user runs it?

 

[mrdenny]

You could schedule the procedure to run each time the SQL Agent starts.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com