SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL 2008 r2 version comparison

Comparison between Enterprise and Standard Versions of SQL 2008 R2

I’ve found myself recently trying to justify the need for Enterprise edition over Standard, with financial contraints being what they are at the moment.

Below is some basic information:-

Enterprise supports database snapshots, indexed views, enhanced read-ahead and scan,  online operations, resource governor, backup compression, hot-add memory and CPU support, fast recovery, online page and file restore, parallel index operations these are not supported in Standard. Security technologies such as Transparent Data Encryption, Advanced third-party key management, Security auditing are limited in Standard edition.

This and more information can be found at:-


High Level Feature Comparison SQL Server 2008 Enterprise SQL Server 2008 Standard
Number of CPUs OS Maximum 4
Scalability & Performance FULL PARTIAL/LIMITED
High Availability (Always on) FULL PARTIAL/LIMITED
Data Warehousing FULL NONE
Business Intelligence FULL PARTIAL/LIMITED
Enterprise Manageability FULL PARTIAL/LIMITED
Programmability FULL FULL


Posted by sven.goossens on 9 August 2011

SQL 2008 R2 Standard Edition supports backup compression!

Leave a Comment

Please register or log in to leave a comment.