Why use SQL Server 2008 Enterprise instead of Standard?

Oopps! Upgrade your browser pretty please.Oopps! Upgrade your browser pretty please.

I have many times recieved the question from various customers, why should I pay so much extra for Enterprise edition? Do I really need it? Well, as usual, the answer is: it depends. But I have compiled a list with the features in Enterprise Edition (of SQL Server 2008) that I actually find so useful that it might warrant the extra cost. Of course there are many other differences between Standard and Enterprise editions, but these are the ones that matters. According to me 🙂

 

Why use SQL Server 2008 Enterprise instead of Standard?

 

 

 

 

Feature

Enterprise

Standard

Comment

Max memory

2 TB

64 GB

Not an issue in most cases

Data compression

Yes

No

Can save disk and memory space, and improve performance

Resource Govenor

Yes

No

Good for consolidated systems, or to make sure that reporting does not impact OLTP too much

Rebuild Index Online

Yes

No

Lets you rebuild indexes online, without disturbing the running applications. A must for real 24/7

DBCC online

Yes

No

Consistency checking without blocking your users. Good for real 24/7

Advanced Read Ahead/Scan

Yes

No

Improves I/O performance

Backup Compression

Yes

No

Improves backup performance/Lowers the need for space

Mirroring

Full

Limited

Performance is better with Enterprise

Database snapshots

Yes

No

 

SSRS Datadriven subscriptions

Yes

No

Example: If condition x is true then I want a copy of that report….