Can you please tell me how to solve the below error in sql server.
Error: SQL Server has encountered 7 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
asked Feb 22 '12 at 05:36 AM in Default
There could be many reasons as the message states itself "due to some database maintenance or reconfigure operations". Since you did not mention your environment, I am posting one of the many reasons
answered Feb 22 '12 at 05:56 AM