[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Starting Up Database

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Starting Up Database.


Applies to: Microsoft SQL Server 2005 Express
 


Message.


Examining the SQL Server error log of a Microsoft SQL Server 2005 Express Instance that manage SharePoint databases we found the following record repeated many times:

Date 10/2/2008 5:10:56 PM
Log SQL Server (Current - 12/8/2008 3:01:00 PM)

Source spid82

Message
Starting up database 'SharedServices1_Search_DB_780d2d71-8175-4cee-a37c-ba4de4a20620'



Cause.

In SQL Server 2005 Express databases will auto_close every 300 milliseconds, to allow databases to be handled like any other file in Windows, allowing to backup databases using XCopy command.
 

Solution.

If you do not like the amount of records Auto_close creates in SQL Server error log or you are experiencing performance degradation on your database because it is frequently accessed, then turn Auto_close off (change it to false).






References.

Understanding SQL Express behavior: Idle time resource usage, AUTO_CLOSE and User Instances.



 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.