On: SQL Server 2014 Standard Edition Sucks

[yuhong]

I wonder which edition StackExchange use?

[BrentOzar → yuhong]

> I wonder which edition StackExchange use?

Enterprise for the memory and the ability to do online reindexing. They were in the BizSpark program, so they basically got free licensing.

[yuhong → BrentOzar]

And they are on Software Assurance, right?

[BrentOzar → yuhong]

Yes, when you exit BizSpark, you can just start paying maintenance on the servers you were using during the program.

[daigoba66 → yuhong]

I'm fairly certain they use Enterprise because they make use of AlwaysOn Availablility Groups.

[BrentOzar → daigoba66]

Before AGs came out, they used a custom log shipping script for DR, and mirroring for the critical DBs. I don't think they would have gone Enterprise just for the AGs, but since they were on EE anyway, AGs were an easy decision.