What are the Limitations of SQL Server Express Edition ?

by Ginktage | Tuesday, Mar 26, 2013 | 462 views

Microsoft SQL Server comes in different versions that includes

  • SQL Server Enterprise
  • SQL Server Business Intelligence
  • SQL Server Standard
  • SQL Server Web
  • SQL Server Express

I have been using SQL Server Express 2012 for quite some time . What are the limitations of SQL Server Express compared to the other versions of SQL Server ?

In this blog post , let’s find out few the limitations of SQL Server Express Edition.

What are the Limitations of SQL Server Express Edition ?

The Express Edition of the SQL Server works great for most of the scenarios like the higher version of SQL Server but some of the limitations include

  • Maximum memory utilized by SQL Server Database Engine is 1GB .
  • Maximum size of the each relational database is 10 GB.
  • No SQL Profiler
  • Dedicated admin connection under trace flag
  • Single CPU (prior to 2008 R2 Express).
  • Maximum number of SQL Server Express instances = 16 on a machine.

Until now , SQL Server Express edition has been working well for me and i plan to try out the higher version of SQL Server in sometime :)

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.
Like it? Share it!

1 Comment so far. Feel free to join this conversation.

    Leave A Response