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, 2012 at 05:36 AM in Default

avatar image

Sakthivel
129 9 9 12

(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, 2012 at 05:56 AM

avatar image

Usman Butt
13.9k 6 12 21

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, 2012 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, 2012 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, 2012 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.

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: Feb 22, 2012 at 05:36 AM

Seen: 3399 times

Last Updated: Feb 22, 2012 at 06:58 AM

Copyright 2016 Redgate Software. Privacy Policy