SQL server 2005 Editions
The SQL Server 2005 family includes a number of editions—Express, Workgroup, Standard and Enterprise . Each of these editions comes with a range of features. These include high availability, Scalability to high business Intelligence tools—all aimed at empowering the organization and catering to mission critical information streaming down the levels in accordance with the security and authentication policies defined. The low cost mainstream database gives value and functionality and is a dramatic step forward in reducing application downtime. The following table indicates the scalability and performance parameters of the different editions.
Scalability and Performance
|
Feature |
Express |
Workgroup |
Standard |
|
Comments |
|
Number of CPUs |
1 |
2 |
4 |
No Limit |
Includes support for multi-core processors. |
|
RAM |
1 gigabyte (GB) |
3 GB |
Operating system maximum |
Operating system maximum |
Memory limited to maximum supported by operating system. |
|
64-bit Support |
Windows on Windows (WOW) |
WOW |
Yes |
Yes |
|
|
Database Size |
4 GB |
No Limit |
No Limit |
No Limit |
|
|
Partitioning |
|
|
|
Yes |
Support for large-scale databases |
|
Parallel Index Operations |
|
|
|
Yes |
Parallel processing of indexing operations |
|
Indexed Views |
|
|
|
Yes |
Indexed view creation is supported in all editions. Indexed view matching by the query processor is only supported in Enterprise Edition. |
High Availability
|
Feature |
Express |
Workgroup |
Standard |
|
Comments |
|
Database Mirroring1 |
|
|
Yes2 |
Yes |
Advanced high availability solution that includes fast failover and automatic client redirection |
|
Failover Clustering |
|
|
Yes3 |
Yes |
|
|
Backup Log-shipping |
|
Yes |
Yes |
Yes |
Data backup and recovery solution |
|
Online System Changes |
Yes |
Yes |
Yes |
Yes |
Includes Hot Add Memory, dedicated administrative connection, and other online operations |
|
Online Indexing |
|
|
|
Yes |
|
|
Online Restore |
|
|
|
Yes |
|
|
Fast Recovery |
|
|
|