Microsoft SQL Server Express, a freely-downloadable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications. Unlike its predecessor, MSDE, it lacks a concurrent workload-governor to "limit performance if the database engine receives more work than is typical of a small number of users."[1] It does, however, have a number of technical restrictions which make it undesirable for large-scale deployments, including:
- maximum database size of 4 GB per database (compared to 2 GB in the former MSDE). The 4 GB limit applies per database (log files excluded); but in some scenarios users can access more data through the use of multiple interconnected databases.
- hardware-utilization limits:
- Single physical CPU, multiple cores[2]
- 1 GB of RAM (runs on any size RAM system, but uses only 1 GB)
- absence of the SQL Server Agent service
Although its predecessor, MSDE, generally lacked basic GUI management tools, SQL Server Express includes several GUI tools for database management. These include:
- SQL Server Management Studio Express
- SQL Server Configuration Manager
- SQL Server Surface Area Configuration tool
- SQL Server Business Intelligence Development Studio.
A relatively late[when?] addition to the SQL Server Express product-line is a reduced-functionality version of SQL Server Reporting Services.
Features available in SQL Server "Standard" and better editions but absent from SQL Server Express include for example:
See also
- SQL Server Compact
- Microsoft SQL Server
- Windows Server System
- List of relational database management systems
- Comparison of relational database management systems
References
- ^ "The SQL Server 2000 Workload Governor". MSDN. January 2004. http://msdn2.microsoft.com/en-us/library/Aa224554(SQL.80).aspx. Retrieved 2007-01-15.
- ^ "How SQL Server 2005 Express Edition determines the CPU count and uses the CPUs during processing". MSDN. November 2008. http://support.microsoft.com/kb/914278. Retrieved 2008-11-25.
External links
- SQL Server 2005 Express Edition product page at microsoft.com
- SQL Server 2008 Express Edition product page at microsoft.com
- SQL Server 2008 Express - Get Started Now! download page at microsoft.com
- SQL Server 2008 Pricing and comparison of features by edition
- SQL Server Express WebLog
|
||||||||||||||||||||||||||||
This entry is from Wikipedia, the leading user-contributed encyclopedia. It may not have been reviewed by professional editors (see full disclaimer)
