question

xypher avatar image
xypher asked

SQL Standard or Enterprise

I have recently noticed that we have many instances of SQL Standard in our environment, but not Enterprise. What would be the real benefit of Enterprise over Standard? I am concerned we are may not be getting the full benefit that a company truly needs.
sqlversion
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

xypher avatar image xypher commented ·
Thanks for all the excellent answers. This will give me some background knowledge for future projects.
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
If an answer has helped, please mark it as correct (the green tick). That way, everyone knows you have been helped.
0 Likes 0 ·

2 Answers

·
Tim avatar image
Tim answered
@xypher, it really all comes down to the cost/benefit analysis. Enterprise Edition is very costly. If you are not installing SQL on a massively powerful server then the fact of Enterprise Ed supporting more ram and processors over standard doesn't matter. If you don't need compression, partitioning, etc of Enterprise then Standard is good enough. Back with SQL 2000 only Enterprise would support log shipping so many companies were forced into Enterprise for HA and DR. With 2005 and above Mirroring and Log Shipping are a feature set of Standard. The link that @kenJ provided has the answers you are looking for. Mainly with @williamD's link of [Features]( http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx)
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
re: log shipping - that's not the full story! We (and, presumably, many other companies) implemented their own version of Log Shipping using SQL Server Standard. I think I've still got the scripts I developed ten years ago...
0 Likes 0 ·
KenJ avatar image
KenJ answered
This was just asked earlier today. You would end up with many of the same answers. You can check them out here: http://ask.sqlservercentral.com/questions/36679/which-edition-should-i-choose-enterprisestandard
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.