I have a lot of "cachestore flush" events on my production server of my web application.
SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
Its bound trees and 2 other things that are coming up on the event log. Now a lot of people are saying that the best practise is to keep the AUTOClose property of the SQL DB as FALSE especially on the production server. This should solve the problem.
Now my question is: Can this cachestore flush problem, that causes a decrease in query performance (according to websites) actually cause a shutdown of the SQL server service?
And is there any way to find out when the sql server service was shutdown on the event log? Theres no log of it on my event log (just an error for some DB trying to connect and it failed, I am basing the time the service shutdown on this event). So basically can this cachestore flush issue terminate the service?