SQL Express Limitations

Here some limitations about SQL express editions:



1.       SQL Server 2012 Express editions are limited to the lesser of one socket or four cores.
2.       The maximum memory for the database engine is limited to 1GB and the maximum relational database size is 10GB.
3.       Although SQL Server Express is limited in scalability, a common misconception is that it’s limited to a single database or 10 connections.
4.       SQL Server Express can support multiple databases where each database can be up to 10GB
5.       SQL Server 2012 Express has no limits on incoming connections or workload other than the CPU and memory limitations. And it comes in both 32-bit and 64-bit versions.
6.        SQL Server Express (Database Only)
a.       The basic offering of SQL Server 2012 Express, SQL Server Express (Database Only) edition includes only the relational database engine.

Many GFI Products can make use of SQL Express databases. However, it is important to note that these databases have strict size limits, which may inhibit the amount of data that a GFI application can store in them. These limits are as follows:
  • Microsoft SQL Server 2005 Express edition has a database size limit to 4GB
  • Microsoft SQL Server 2008 Express edition has a database size limit to 4GB
  • Microsoft SQL Server 2008 R2 Express edition has a database size limit to 10GB
  • Microsoft SQL Server 2012 Express edition has a database size limit to 10GB
  • Microsoft SQL Server 2014 Express edition has a database size limit to 10GB