Geek Answers Handbook

SQL Server 2008 R2 Express - instances constantly running the database

I have 3 instances of SQL Server 2008 R2 Express to try to circumvent the 1gb limit for express editions. Instance 1 (SQLExpress) is attached to my busiest website, serving about 3,000 concurrent online users. This database is functioning properly.

I also run two other instances (SQLExpress1 and SQLExpress2) attached to much quieter sites. In both cases, I see that the databases are constantly running:

02/11/2010 20: 18: 24, spid53, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 19: 34: 43, spid52, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 19: 17: 17, spid54, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 19: 02: 37, spid51, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 18: 54: 27, spid51, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 18: 41: 27, spid51, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 17: 56: 28, spid51, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 17: 44: 13, spid52, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 17: 33: 25, spid53, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 17: 33: 21, spid53, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 17: 19: 04, spid51, Unknown, Starting the 'historiaslush_forums' database. 02/11/2010 17: 18: 55, spid53, Unknown, Starting the 'historiaslush_forums' database.

Has anyone seen this behavior before? Is this related to a set of distorted functions with the version of the expression?

thanks

+4
source share
2 answers

By default, SQL Express databases are created as AUTO_CLOSE ON . Thus, they are closed as soon as the last session releases access to it. They will automatically open at the next access. AUTO_CLOSE databases run optimized recovery upon opening, so opening them is not as bad as an open fully open database. But, nevertheless, you can disable AUTO_CLOSE if you want:

 ALTER DATABASE historiaslush_forums SET AUTO_CLOSE OFF;

As a side note, the AUTO_CLOSE ON database will behave the same in Enterprise Edition, so this is not related to Express restrictions.

+8
source

In the database, you have the AutoClose property set to

+1
source

More articles:


All Articles