Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm aware that the SQL Server 2008 R2 Express was limited to 1 CPU and 10 GB Databases. It's not clear if Microsoft bumped those numbers up to be more reflective of 2012. I looked at several places but I still don't have a clear idea. Yes, I understand 2012 is not yet released but I have to assume it's software performance requirements are already set.

share|improve this question
2  
I have never really noticed all that much of a performance problem using 1 CPU. If your database is unimportant enough to not have Maintainance plans (which Express doesn't have) then I bet your database is also not getting hit hard enough to matter. –  djangofan Jan 17 '12 at 20:34

4 Answers 4

up vote 6 down vote accepted

As far as I am aware there has been no official announcement of the capabilities of SQL Express 2012, although I have heard rumours that it will be the same as 2008 R2 (1 CPU and 10Gb database limit).

Microsoft have released specifications for the standard and enterprise editions.

share|improve this answer
3  
The limits are available now: msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx –  skolima Aug 23 '12 at 10:36

Now that it's been in release mode, there's more information available on SQL Server 2012 Express. It looks like you're limited to:

  • 1 physical cpu (up to 4 cores)
  • 1GB of memory use
  • up to 10GB per database.
share|improve this answer

Please refer to this page:

http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx

share|improve this answer
5  
Welcome to Server Fault! Answers that consist of nothing more than a link to another site are generally frowned upon - we prefer to see you incorporate the relevant information here, as Microsoft will inevitably reorganize their website and break that link one day. See this meta topic for more information. –  voretaq7 Apr 3 '12 at 22:28

Yes, I understand 2012 is not yet released but I have to assume it's software performance requirements are already set.

You can't assume this - the limits of the Express Editions are not technical by nature. And as something specified by marketing, it can change any time - shortly before the product's release or even after that, where the updated code gets distributed through a service pack.

share|improve this answer
1  
Technical or marketing, it's way more common for high level product specifications to be set ahead of product launch. (i.e. product planning) –  DeepSpace101 Jan 31 '12 at 6:42
2  
@sid You've never been to Redmond, have you? –  the-wabbit Jan 31 '12 at 11:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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