Eftersom licenskostnaderna skiljer sig ganska mycket så är det vanligt att välja Standard edition och…
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…. |