Haven’t checked Windows Server’s event log for a long time, we noticed that there a a lot of strange SQL Server 2008 R2 entries like “Starting up database XXX”.
Apparently, this issue is caused by “AutoClose” property which is set to True (by default).
MSDN stated that if AutoClose property is set to True and there isn’t any database connection, then the database will be closed and the resources will be freed.
In production server, where database is accessed regularly, there will be cost for starting up database.
Long story short, don’t forget to turn AutoClose property off.