• Meredith Ryan (12/19/2007)


    majorbloodnock (12/17/2007)


    I'm a little rusty on licensing options now, since it's a while since I had that particular responsibility in my current company. However, last time I made a comparison, the water was muddied quite a bit based on the whole area of development environments.

    At that point, Oracle charged quite a bit per processor for any production installation, whilst SQL Server was far cheaper, but required licenses for every installation. Given any of our mainstream applications have a production, test, development and (usually) at least one sandpit environment, that means SQL Server had to be less than a quarter of the per processor price of Oracle to be fiscally competitive. And that, of course, was before we took into account the high-volume capabilities of different platforms (the gap's closing, but at that point Solaris provided a clear advantage, effectively ruling out SQL Server at the first hurdle).

    Now, if MS moved to a Production Instances Only licensing model, that'd really be something to think about.

    Not quite. With each MSDN dev seat you get accesss to OS's and Server licenses for dev/test. The cavat here is that those installs are only used for dev/test. So, you buy your testers and dev folk MSDN seats and your licensing issues are mute. Also, they get the added advantage of the MSDN resources.

    Thanks, Meredith. That makes a lot of sense, and clarifies well.

    However, and it's a big however, it's got me thinking - dangerous at the best of times. What about test environments that are used for UAT? If your user testing base is a random selection of perhaps 50 or 100 from a potential audience of thousands, does that not still mean you have to buy a full SQL Server license for that box? Obviously this still doesn't make the situation as bad as it seemed in my first posting, but it feels like a cost that is, if not hidden, at least obfuscated. Or am I just being obtuse?

    Semper in excretia, suus solum profundum variat