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, 2012 at 07:38 PM in Default

avatar image

inder
211 18 19 25

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

3 answers: sort voted first

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

more ▼

answered Mar 15, 2012 at 07:56 AM

avatar image

Usman Butt
14k 6 13 21

(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.

more ▼

answered Mar 14, 2012 at 05:54 PM

avatar image

Blackhawk-17
12k 30 35 42

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

We have notied this in one of our environment. But i have checked auclose options for all the databases in that instance. SELECT * FROM SYS.DATABASES I have run the DBCC FREESYSTEMCACHE ('ALL') Command. nothing helps. in microsoft website, i saw this https://support.microsoft.com/en-us/kb/917828 but it did not suggest any fix even. Do you think that installing sp3 will fix this issue?

more ▼

answered May 14, 2015 at 09:06 PM

avatar image

sql_hunter
140 5 9 13

(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.

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:

x86

asked: Mar 13, 2012 at 07:38 PM

Seen: 6597 times

Last Updated: May 14, 2015 at 09:06 PM

Copyright 2016 Redgate Software. Privacy Policy