Restore plan cache and buffer pool after database restore?

by Conrad S.   Last Updated October 18, 2019 21:06 PM - source

When restoring a database, is there a way to restore the plan cache so it doesn't have to be re-created during production use?

Similar question: is there a way to pro-actively restore the buffer cache during or after a database restore?,…. other than to create and run select statements on the tables previously in the buffer cache, a solution which would be time-consuming to create, and inevitably inaccurate.

This is a followup to this question: "Does restoring database clear buffer cache and stored proc cache"



Related Questions




SQL Buffer Pool and Plan cache

Updated July 24, 2018 20:06 PM

Memory Usage by SQL Server

Updated July 23, 2018 22:06 PM

How does MySQL evict pages from the buffer pool?

Updated December 26, 2018 20:06 PM