485 - AS: Event logs show "SQL Server has encountered 1 occurrence(s) of cachestore flush"

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 Storage Platform 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.