SQL Cachestore flush
Posted by: SQL Server DBA,
on 20 Jan 2012 |
View original | Bookmarked: 0 time(s)
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
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.
Notes:
1) When the plan cache clears , a recompilation is forced , this can cause a temporary performance decrease
2) Using...