Update 2012.03.20: This article can be deleted soon, SQL 2012 Express is delivering the LocalDb feature to be used instead of RANU.

 

http://blogs.msdn.com/b/sqlexpress/archive/2008/02/22/sql-express-behaviors-idle-time-resources-usage-auto-close-and-user-instances.aspx

 

 

The conclusion is at setup it would be good to execute some operations with the database to initialize RANU. Then, ensure when the application starts, that the connection does not timeout. Also, some measurements are needed to ensure the user’s system is not killed by this second instance of SQL Server.

Advertisements