SQL Server Express

From Wikipedia, the free encyclopedia

Jump to: navigation, search
 It has been suggested that MSDE be merged into this article or section. (Discuss)

Microsoft SQL Server Express is the freely-downloadable and distributable version of Microsoft's SQL Server relational database management system. It offers a database solution specifically targeted for embedded and smaller-scale applications. Unlike its predecessor, MSDE, there is no concurrent workload governor which "limit[s] 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 is per database (log files excluded) and can be extended in some scenarios 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 SQL Server Agent Service

Although its predecessor, MSDE, was virtually devoid of basic GUI management tools, SQL Server Express includes several GUI tools for database management. Among these tools are:

A relatively late addition to the SQL Server Express product line is a reduced functionality version of SQL Server Reporting Services, but features such as Analysis Services, Integration Services, and Notification Services are only available in the "Standard" edition and higher editions.

[edit] See also

[edit] References

  1. ^ "The SQL Server 2000 Workload Governor". MSDN. January 2004. http://msdn2.microsoft.com/en-us/library/Aa224554(SQL.80).aspx. Retrieved on 2007-01-15. 
  2. ^ "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 on 2008-11-25. 

[edit] External links

v • d • e
Microsoft development tools
Development
environments
Languages and
compilers
Major APIs and
frameworks
Database tools
and languages
SQL services
Other
Source control
Driver development
Retrieved from "http://en.wikipedia.org/wiki/SQL_Server_Express"
Personal tools
Languages