I notice from my event logs that we are receiving a lot of cachestore flush notices and then subsequent notices of databases being opened.
The situation is better described in the post http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24072323.html?sfQueryTermInfo=1+cachestor+flush
I see that I could probably get rid of these notices by setting each database auto close setting to off but I'm wondering whether from a performance point of view it is better to close, flush and then reopen or set the auto close to false and leave them open all the time.
The environment is Windows 2003, SQL Server Express and we're running abourt 20-30 websites which utilise SQL Server Express.
It should be noted that we are not currently having any performance issues relating to SQL Server.