Limitations of SQL Server 2012 Express version?
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.
Solution 1:
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.
Solution 2:
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.
Solution 3:
Please refer to this page:
http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx