Monday, October 11, 2010

Limitations of SQL Server Express 2008

For those of you who need this information, the limitations of SQL Server Express 2008 are essentially the following ones:

  • 1 CPU (It is unable to scale to use multiple processors. So If a system has more than 1 SQL Express 2008 will still run but limit itself to 1 CPU.)
  • 1 GB of RAM (More RAM can be installed, but again SQL Express 2008 will only make use of a maximum 1 GB.)
  • 4Gb maximum for each database (not global storage)
  • Unlimited users
  • No SQL Server Agent service
  • No SQL profiler
  • Still has support for procedures, triggers & functions
  • Need Management Studio Express or higher to manage the instance (SQL Server Management Studio Express (SSMSE). This is downloadable as a standalone tool or integrated with a SQL Server Express edition at no charge.
If you’re able to cope with these limitations, SQL Server 2008 Express may be the best choice for you.

Otherwise, a great improvement comes with SQL Server Express 2008 R2 which is still free and where the maximum database size limit has been raised from 4 GB to 10 GB.

Another option to consider for database developers is the Developer Edition. Unlike Express Edition, Developer Edition has no limitations on database size, performance characteristics or functionality. However, it’s only licensed for use by a single developer in a non-production development environment.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...