I would like to use Express instead of Standard. Does Express still have the annoying habit of going to sleep if left unused for a period of time?

  • 1
    Do you mean the AutoClose property of a database or is there some other kind of "going to sleep" you have in mind? – Mikael Eriksson Feb 22 '15 at 18:40
  • The SQL Express limitation kind. This post is quite recent so I guess its still there.... stackoverflow.com/a/26168739/221683 – Ian Warburton Feb 22 '15 at 18:43
  • SQL express does have lot of limitations as compared to Standard edition. One thing is gr8 for express its free and if it does your task you can stick to it – Shanky Feb 22 '15 at 19:14
  • 10Gb a database, one CPU and a single GB of memory is plenty OK for me I think. – Ian Warburton Feb 22 '15 at 19:16
  • 1
    Memory is NOT LIMITED to just 1 G database engine instance can use more than 1 G starting from SQL Server 2012 express – Shanky Feb 23 '15 at 4:29

No, it does't, and never did.

The post you link links to the blog http://blogs.msdn.com/b/sqlexpress/archive/2008/02/22/sql-express-behaviors-idle-time-resources-usage-auto-close-and-user-instances.aspx that explains that the 'instance going to sleep' is a RANU behavior (user instance), not an Express behavior. As you plan to move from Standard to Express, is obvious that that you do not plan to move to user instances (RANU).

  • Sounds good. I will give it a go. – Ian Warburton Feb 22 '15 at 18:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.