Comparing Standard Editions of SQL Server

re: Comparing Standard Editions of SQL Server

Jack — Tue, 10 Jul 2012 13:43:27 GMT

Great post - could you add 2005 Standard to the chart?

re: Comparing Standard Editions of SQL Server

jerryhung — Tue, 10 Jul 2012 14:57:35 GMT

Thanks for the post

Although I'd say upgrading from SQL 2008 Std to 2012 Std is not a big leap, especially the leap in licensing $$ (per socket to per core)

re: Comparing Standard Editions of SQL Server

RickHeiges — Tue, 10 Jul 2012 15:32:28 GMT

@Jack - I actually started down that road but found the list of features immense. Think about the chart this way - the major diffenecea obtained from upgrading from SQL Server 2005 to 2008/2008R2/2012.

@jerryhung - I agree. And there are plenty of other posts out there already concerning the licensing changes. :-)

re: Comparing Standard Editions of SQL Server

AaronBertrand — Tue, 10 Jul 2012 15:36:52 GMT

@jerryhung it is only a big leap if you have > 4-core processors. For most users, the "leap" is horizontal, since a core license in 2012 is about 1/4 the price of a processor license in 2008. In 2012 it is $1,793 per core; in 2008 it was $7,499 per processor. So if you have processors with <= 4 cores, your cost has actually gone down a bit, by my math.

re: Comparing Standard Editions of SQL Server

AaronBertrand — Tue, 10 Jul 2012 15:38:30 GMT

Also as for whether or not it is a "leap" I point out several of the enhancements you get even in Standard Edition here:

http://dba.stackexchange.com/questions/14730/what-are-objective-business-reasons-to-prefer-sql-server-2012-over-2008-r2/14731#14731

re: Comparing Standard Editions of SQL Server

Ola Hallengren — Tue, 10 Jul 2012 19:08:30 GMT

Database Mirroring (synchronous mode) is available in Standard Edition from SQL Server 2005 to SQL Server 2012.

Database Mirroring is going away and the future is AlwaysOn Availability Groups. AlwaysOn Availability Groups is only available in Enterprise Edition.

"AlwaysOn Availability Groups"

"If your edition of SQL Server does not support AlwaysOn Availability Groups, use log shipping."

http://msdn.microsoft.com/en-us/library/ms143729.aspx

re: Comparing Standard Editions of SQL Server

Ian Yates — Fri, 13 Jul 2012 05:22:33 GMT

It is annoying that, as a Microsoft partner, we get offered all sorts of training that we can attend, but all of that training seems to focus on features only in the Enterprise Edition. We're an ISV who sometimes have trouble getting standard edition purchased by our clients. Only one runs the Enterprise Edition and that's because they're government. Thank you for talking about standard edition :)

Part of our software now requires at least SQL 2008 R2 becuase of the nice changes to reporting services there - specifically shared datasets, cross-dataset lookups and the "sync data across groups" functionality which makes time-series graphs down the page, one per group, a doddle. That alone is worth the price of upgrading for me as a developer / report writer.

The gee-whiz reporting stuff, such as PowerPivot/PowerViewer, need SharePoint and Enterprise Edition (or BI edition I suppose). I can convince client IT to let us set up and manage an instance of SQL but SharePoint, apart from its cost, is a battle I'd lose due to stubborn IT :P

re: Comparing Standard Editions of SQL Server

noeldr — Mon, 16 Jul 2012 19:21:34 GMT

@Aaron: In my _home_ computer I have 4 cores!

Imagine you have any of the new intel procs with 10 Cores and two processors server... Welcome To License price HELL and if you need more than 64GB of RAM you will simply be out of luck.

--> Enterprise Edition is simply too expensive.

You could spend $25K on a new HW and your license could be $140K,

go figure ( http://www.brentozar.com/archive/2012/06/i-learned-at-msteched-north-america-last-week/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+BrentOzar-SqlServerDba+%28Brent+Ozar+PLF%29 )

@RickHeiges:

Standard Edition in SQL 2008 Had _no_ memory limits, that was introduced in R2

re: Comparing Standard Editions of SQL Server

Justin Dearing — Thu, 13 Sep 2012 21:30:44 GMT

I find it interesting that you find the key benifit of core server "reduced patching".

Yes, regardless of automation, patches take time, but for me the reduced vulnerability footprint of less code, which is the cause of less patching and less ability to waste server resources through things like RDP sessions are the real wins.

Then again, maybe because I'm a developer, not a DBA. I don't have to apply the patches.

re: Comparing Standard Editions of SQL Server

Ben — Fri, 14 Sep 2012 04:19:07 GMT

SQL 2008 Standard was limited in the number of CPUs and the amount of memory to that of the Host operating system.

I am currently running SQL 2008 Standard with 24 cores and 136 gig of ram.

re: Comparing Standard Editions of SQL Server

tcstl — Wed, 05 Jun 2013 14:33:03 GMT

Disappointed by the memory limit on standard edition MS states to better align features, time to look at mysql