[KBA-01044] SQL Server 2008 Edition comparison - Security Center 5.4 - 5.8 | Omnicast™ 4.6 - 4.8

series
Security Center 5.4 - 5.8 | Omnicast™ 4.6 - 4.8
revised_modified
2014-04-25

[KBA-01044] SQL Server 2008 Edition comparison

This article explains the main differences between the SQL 2008 editions that are supported with Genetec™ software.

Summary

Microsoft SQL 2008 has multiple editions. The following table describes the main differences between the SQL 2008 editions that are supported by Genetec™.

For complete Microsoft SQL 2008 specifications, refer to the Microsoft SQL site.

Feature 2008 Express 2008 Standard 2008 Enterprise
Number of CPUs 1 4 8
Memory utilization 1 GB RAM 64GB RAM 2TB RAM
64-bit support Yes Yes Yes
Database size 10 GB 524 PB 524 PB
Database mirroring Witness Yes (Single) Yes (Full)
Failover clustering Yes Yes
Auto tuning Yes Yes
SQL Server Management Studio Express Yes Yes Yes
Management Studio Yes Yes
Advanced Auditing, Authentication, and Authorization Yes Yes
Data encryption and key management   Yes
Integration with Microsoft Baseline Security Analyzer Yes Yes Yes
Integration with Microsoft Update Yes Yes Yes