Looking through the error log on our DR boxes I found that our SQL Server 2005 are all generating errors that look like below:

SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

cachestoreFlush

there can be multiple reasons for this (read more about them here: sangeethashekar – 10.0 Plan Cache Flush)

For me it timed in perfectly with our a log shipping restores.

Advertisements