Who is Using Standard Edition?

Question

Who is Using Standard Edition?

Steve Jones - SSC Editor

SSC Guru

Points: 738643
More actions
August 15, 2025 at 12:00 am

#4610679

Comments posted to this topic are about the item Who is Using Standard Edition?

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

David.Poole SSC Guru Points: 76195 More actions · Answer 1

That's 2 of your April Fools' jokes that have turned out to be prescient!

I've been thinking about per-core licensing concerning software, not just SQL Server. I understand that software companies have to make money. What does the purchaser get for the additional outlay? Does a company running a multi-core system require more from the vendor, such as the cost of providing support?

The worst experience I had was getting the proposed bill for connecting Oracle ODI (Oracle's ETL tool) to a Hadoop cluster. Oracle want to charge for every node in the source and every node in the target. The cost was well into 7 figures, negating any revenue generated by using that Hadoop cluster. As far as I could see, at the time, installation was placing an agent in the master nodes of the Hadoop cluster. 3 Node install, but being charged for many worker nodes.

LinkedIn Profile

awinter SSC Enthusiast Points: 111 More actions · Answer 2

Would love to have a standard edition of developer version. I've written queries that perform fantastic in development, but horrible in production only to find out the plan optimizer used an enterprise feature that I had to manually disable so I could properly tune the query in a standard environment equivalent.

cgumprich Ten Centuries Points: 1107 More actions · Answer 3

We have an estate of fifteen servers and almost two hundred databases to watch over, and we have Enterprise installed on all systems. It didn't happen right away, it's the result of years of bundling our renewals.

david.gugg SSCertifiable Points: 6173 More actions · Answer 4

My current company didn't have a DBA before I got there, so everything went in as Enterprise (smh). I've been slowly introducing Standard in where it would be more appropriate.

Be still, and know that I am God - Psalm 46:10

TL SSC-Addicted Points: 473 More actions · Answer 5

My team has 230 SQL boxes that we support in our environment and only 8 of them are enterprise edition. For us, outside of BI features there isn't anything in Enterprise Edition that justifies the cost.

Steve Jones - SSC Editor SSC Guru Points: 738643 More actions · Answer 6

David.Poole wrote:

That's 2 of your April Fools' jokes that have turned out to be prescient!
I've been thinking about per-core licensing concerning software, not just SQL Server. I understand that software companies have to make money. What does the purchaser get for the additional outlay? Does a company running a multi-core system require more from the vendor, such as the cost of providing support?
The worst experience I had was getting the proposed bill for connecting Oracle ODI (Oracle's ETL tool) to a Hadoop cluster. Oracle want to charge for every node in the source and every node in the target. The cost was well into 7 figures, negating any revenue generated by using that Hadoop cluster. As far as I could see, at the time, installation was placing an agent in the master nodes of the Hadoop cluster. 3 Node install, but being charged for many worker nodes.

The purchaser gets nothing, but that's the way of the world. Those who have leverage can exploit it.

Steve Jones - SSC Editor SSC Guru Points: 738643 More actions · Answer 7

awinter wrote:

Would love to have a standard edition of developer version. I've written queries that perform fantastic in development, but horrible in production only to find out the plan optimizer used an enterprise feature that I had to manually disable so I could properly tune the query in a standard environment equivalent.

https://www.red-gate.com/simple-talk/databases/sql-server/sql-server-developer-standard-edition-a-gift-to-developers/

Steve Jones - SSC Editor SSC Guru Points: 738643 More actions · Answer 8

david.gugg wrote:

My current company didn't have a DBA before I got there, so everything went in as Enterprise (smh). I've been slowly introducing Standard in where it would be more appropriate.

Good move. I always tried to keep costs down if we could. I saw plenty of 4-8core systems with EE on them and thought wow.

Steve Jones - SSC Editor SSC Guru Points: 738643 More actions · Answer 9

TL wrote:

My team has 230 SQL boxes that we support in our environment and only 8 of them are enterprise edition. For us, outside of BI features there isn't anything in Enterprise Edition that justifies the cost.

I think for many systems, this is true.

cgumprich Ten Centuries Points: 1107 More actions · Answer 10

I admit to some surprise that our company seems to be the exception with our all-Enterprise setup. Yes, it comes at a price, but I guess the previous DBAs did a great job at convincing the executives that it was a worthwhile expense.

Jo Pattyn SSC-Dedicated Points: 32470 More actions · Answer 11

Most run on standard edition, only BI has enterprise due bundle with powerbi report server