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." It has a number of technical restrictions (which make it unsuitable for some large-scale deployments) including:
- Maximum database size of 10 GB per database in SQL Server 2008 R2 (4 GB for SQL Server Express 2008 and earlier; 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.
- No SQL Server Agent service
- Hardware-utilization limits:
- Single physical CPU, but multiple cores allowable
- 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, 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
Read more about this topic: SQL Server Express
Famous quotes containing the word capabilities:
“I maintain that I have been a Negro three times—a Negro baby, a Negro girl and a Negro woman. Still, if you have received no clear cut impression of what the Negro in America is like, then you are in the same place with me. There is no The Negro here. Our lives are so diversified, internal attitudes so varied, appearances and capabilities so different, that there is no possible classification so catholic that it will cover us all, except My people! My people!”
—Zora Neale Hurston (1891–1960)