Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

What is the performance point at which it makes sense to get Enterprise instead of Standard Expand / Collapse
Author
Message
Posted Monday, July 22, 2013 9:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 7:27 AM
Points: 20, Visits: 101
We are looking to build a SQL Server server. We are looking to get SQL 2012, but not sure which version to get. At this point, I think Standard is all we need, but to make sure we cover our bases, I need to know at what point does it make sense to get Enterprise. Is there a number of users or a database size, amount of usable memory or something else that would be a reasonable indicator that we should get Enterprise?
Post #1476061
Posted Monday, July 22, 2013 9:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:49 PM
Points: 31,161, Visits: 15,607
Enterprise edition is a bit about features (TDE, Paritioning, etc) and you'd have to check if you need any of those.

It's also about scale, but that's hard to judge. 3 users can bury a SQL Server with poorly written code, large data sets, and complex calculations. Simple web pages can allow a SQL Server to support 10,000 connections.

If you look at the hardware limits, and you can reference some data to get an idea of load, you might be able to guess. If you're testing, use developer edition (don't but SE or EE) and see what level of load you can handle on hardware. Then decide what to buy.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1476069
Posted Monday, July 22, 2013 9:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 7:27 AM
Points: 20, Visits: 101
Unfortunately, we don't really have the time to do a bunch of testing. The server will be hosting a few databases. A couple of them support an intranet application which mostly serves up reports. Nothing overly complicated. We are also installing a couple of new products that will be used by some of the staff. I don't believe there will be a huge number of users hitting the db at any given time. Our primary ERP system used a Progress database, so this is more of a support system. The extra feature set is not a deciding factor. It is really about what the performance break point is.
Post #1476078
Posted Monday, July 22, 2013 10:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
Unless you are planning on using some of the more advanced features or an obscene amount of processors and memory I don't think I would recommend Enterprise Edition. For me the STRONG need for those features or for the additional processor/memory.

EE isn't really faster than SE in the database engine. So if you are equating editions to performance directly I wouldn't.

Given the major cost difference I would not go to EE willy nilly without justification.

CEWII
Post #1476105
Posted Monday, July 22, 2013 10:04 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:58 AM
Points: 96, Visits: 1,287
I'm not sure if this will help you, but there is a feature comparison guide between the different editions:

http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx
Post #1476108
Posted Monday, July 22, 2013 10:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 7:27 AM
Points: 20, Visits: 101
Thanks for the feedback.

I've seen the feature comparison, but that wasn't an issue.
Post #1476113
Posted Monday, July 22, 2013 10:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, October 17, 2014 2:15 PM
Points: 13,077, Visits: 12,523
jplankenhorn (7/22/2013)
Thanks for the feedback.

I've seen the feature comparison, but that wasn't an issue.


If the features are not an issue than go with Standard.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1476115
Posted Monday, July 22, 2013 10:25 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:49 PM
Points: 31,161, Visits: 15,607
I'd tend to say Standard as well. Without the need for Enterprise features, and without a large load you can measure, stick with SE.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1476124
Posted Monday, July 22, 2013 10:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 7:27 AM
Points: 20, Visits: 101
Thank you all. Much appreciated. I have passed on your recommendations to the powers that be.
Post #1476129
Posted Monday, July 22, 2013 11:51 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 4,394, Visits: 6,251
For me the biggest limitation in Standard Edition is the RIDICULOUSLY LOW maximum memory. Fortunately you can supplant that with SSD storage to some degree, although I will caution anyone who thinks that is a magic bullet. PageIOLatch_xx can still get you, but they will be less onerous than the tens to perhaps thousands of milliseconds you may see with rotating media and too little RAM. The other biggie, and I mean potentially non-functional application biggie, is deadlocks. I have had several clients that have started throwing a blizzard of deadlocks after moving to SSD storage, including one that had to roll back to rotating media to get their system reusable!!

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1476173
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse