SQL Error Message

Question

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.

Answer 1

0

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

answered Feb 22 '12 at 05:56 AM

Usman Butt
13.8k ● 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)

SQL Error Message

Follow this question

Related Questions