Attix5 Pro FAQ
Search:     Advanced search

AS: Event logs show 'SQL Server has encountered 1 occurrence(s) of cachestore flush ...'

Article ID: 18
Last updated: 30 Jul, 2010

Symptom:

The following message is repeatedly seen in the event logs:

SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

Cause:

It is because the AUTO_CLOSE option is set to ON in the SP databases.  

The recommended setting by Microsoft is OFF for Servers (and optionally on for Desktops)

Fix:

To turn it off, run the following script on your Sql server:

ALTER DATABASE [StoragePlatform] SET AUTO_CLOSE OFF Go ALTER DATABASE [StoragePlatformReports] SET AUTO_CLOSE OFF.

Go

Article ID: 18
Last updated: 30 Jul, 2010
Revision: 1
Views: 5322
Comments: 0
Posted: 16 Apr, 2010 by Marais D.
Updated: 30 Jul, 2010 by Marais D.
This article was:  
Prev   Next
Article 24 - Increasing the size of the NTFS Change Journal     Article 20 - What happens during the first V6 roll-up on an upgraded platform?