What are the limitations of MS SQL Express?

MS SQL Express is a free distribution of MS SQL server. It means that there are certain limits of its usage described in the table below.

 LimitationMSSQL 2005/2008 ExpressMSSQL 2008R2 ExpressMSSQL 2012 ExpressMSSQL 2014 ExpressMSSQL 2016 Express
The number of simultaneous connectionsno limitno limitno limitno limitno limit
Max. database size4 GB10 GB10 GB10 GB10 GB
Max. RAM usage1 GB1 GB1 GB1 GB1410 MB
The number of used processors1111CPU / 4 core1CPU / 4 core


Was this article helpful?

Related Articles