x

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
more ▼

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

inder gravatar image

inder
211 16 19 22

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

more ▼

answered Mar 15 '12 at 07:56 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(comments are locked)
10|1200 characters needed characters left

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][1].

[1]: http://msdn.microsoft.com/en-us/library/ms181055(v=sql.90).aspx
more ▼

answered Mar 14 '12 at 05:54 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.8k 28 30 35

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x73

asked: Mar 13 '12 at 07:38 PM

Seen: 4290 times

Last Updated: Mar 15 '12 at 08:04 AM