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.
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)
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.
Old Article ID: 18
Posted: 16 Apr, 2010 by Marais D.