What are the Limitations of SQL Server Express Edition ?
Join the DZone community and get the full member experience.
Join For Freemicrosoft 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
Published at DZone with permission of Senthil Kumar, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
Comments