0

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?

5
  • 2
    Do you mean the AutoClose property of a database or is there some other kind of "going to sleep" you have in mind? Feb 22, 2015 at 18:40
  • The SQL Express limitation kind. This post is quite recent so I guess its still there.... stackoverflow.com/a/26168739/221683 Feb 22, 2015 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, 2015 at 19:14
  • 10Gb a database, one CPU and a single GB of memory is plenty OK for me I think. Feb 22, 2015 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, 2015 at 4:29

1 Answer 1

4

No, it does't, and never did.

The post you link links to the blog Link 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).

2
  • Sounds good. I will give it a go. Feb 22, 2015 at 18:49
  • link no longer works.
    – CJBS
    Apr 23, 2020 at 23:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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