Attempts to perform a RESTORE from Live to Test has recently been failing. Reviewing the error logs, I get the message: "SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations". 'Object Plans' als can be 'Bound Trees' and 'SQL Plans'. MSKB Article http://support.microsoft.com/kb/917828 addresses this, but I'm not certain that is the fix. Anyone with experience doing this? Thanks!!
Hi Randall,
I have used dbcc freeproccache on a few occasions and have had no trouble with it. You may see a slight performance drop temporarily, but it doesn't take too long for everything to be cached again.
Good luck with it.
Jeff