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.
-
2I 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
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.
![](../../users/profiles/3462.webp)
- 293
- 3
- 11
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.
![](../../users/profiles/48.webp)
- 38,158
- 6
- 77
- 113
-
3The limits are available now: http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx – skolima Aug 23 '12 at 10:36
Please refer to this page:
http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx
![](../../users/profiles/116348.webp)
- 111
- 2
-
8Welcome 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](http://meta.stackexchange.com/questions/8231/are-answers-that-just-contain-links-elsewhere-really-good-answers) for more information. – voretaq7 Apr 03 '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.
![](../../users/profiles/76595.webp)
- 40,319
- 13
- 105
- 169
-
1Technical 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 06:42
-
3