October 27, 2008 at 5:44 am
The Gurus,
This messages,
"2008-10-27 08:53:27.82 spid16s SQL Server has encountered 54 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2008-10-27 08:53:27.82 spid16s SQL Server has encountered 54 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2008-10-27 08:53:27.82 spid16s SQL Server has encountered 54 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations."
has been appearing in my SQL Server logs for over a month now. Could someone, please, give me an idea of what is causing it and how it could be resolved?
Many thanks.
Sahoong.
October 27, 2008 at 5:50 am
It could be due to a database/log restore. (Is this a logshipping destination?). It could be from certain configuration changes (sp_configure). It could be from someone running DBCC FREEPROCCACHE. It could be due to a database set with autoclose on.
You'll probably have to run profiler for a while to see what's actually happening.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply