x

SQL Error Message

Hi All,

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

asked Feb 22 '12 at 05:36 AM in Default

Sakthivel gravatar image

Sakthivel
109 7 9 10

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

1 answer: sort voted first

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

  • Whenever a restore is performed
  • Log Shipping
  • Detach database operation
  • DBCC FREEPROCCACHE
  • DBCC FREESYSTEMCACHE
  • AUTOCLOSE = ON
  • Low Server Memory
more ▼

answered Feb 22 '12 at 05:56 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

This is SQL server Express Edition and there is no operation regarding DBA.While .net developers are starting some services for some application purpose that time the above SQL error occurred.
Feb 22 '12 at 06:15 AM Sakthivel

Can you please let us know the details, what is "starting some services"? Can you please share the output of the following script OR can see the name of the specific database in the output

SELECT [name] FROM sys.[databases]
WHERE [is_auto_close_on] = 1
Feb 22 '12 at 06:25 AM Usman Butt

Thank you Mr.Usman now i changed AUTOCLOSE = OFF in that particular database still now there is no error regarding that issue.

Actually .net developers create and run new FAX option services fro particular database thats why event log throws the above error.

Thanks once again for your valuable response,,,,,,,,
Feb 22 '12 at 06:58 AM Sakthivel
(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: Feb 22 '12 at 05:36 AM

Seen: 2168 times

Last Updated: Feb 22 '12 at 06:58 AM