Microsoft SQL Server Express, a freely downloadable and distributable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications.
Capabilities
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 has a number of technical restrictions (which make it unsuitable for some large-scale deployments) including:
Maximum database size of 4 GB per database (10 GB for SQL Server Express 2008 R2;[2] compared to 2 GB in the former MSDE). The limit applies per database (log files excluded); but in some scenarios users can access more data through the use of multiple interconnected databases.[citation needed]
No SQL Server Agent service
Hardware-utilization limits:
Single physical CPU, but multiple cores allowable[4]
1 GB of RAM (runs on a system with any RAM amount, but uses only at most 1 GB)
Although its predecessor, MSDE, generally lacked basic GUI management tools,[5] 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.
Features available in SQL Server "Standard" and better editions but absent from SQL Server Express include:
Analysis Services
Integration Services
Notification Services
Source: Wikipedia
0 comments:
Post a Comment