SQL Server Error message for Cachestore Flush

Hi Folks, I have found these error messages in SQL Server Log. "SQL Server has encountered 6 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations."

"SQL Server has encountered 6 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 6 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations."

Any detail like website article related to these messages will be appreciated

asked Mar 13 '12 at 07:38 PM in Default

inder
201 ● 10 ● 16 ● 21

(comments are locked)

2 answers:

The same question was answered here before. Hope it helps.

answered Mar 15 '12 at 07:56 AM

Usman Butt
13.8k ● 6 ● 8 ● 14

(comments are locked)

This can be caused by something as benign as an Alter Procedure statement or by reconfiguring MAXMEM. It is SQL Server performing memory management by clearing out the oldest/least used elements in cache (RAM) to maintain room for the more current/active elements.

It can indicate memory pressures on your system or it may just be behind the scenes clean-up. You will have to dig deeper to determine which it is in your case.

You can read up on it in BOL.

answered Mar 14 '12 at 05:54 PM