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