Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server 2012: Creative Thinking for a Creative New Licensing Model

By Rodney Landrum,

SQL Server 2012 brings with it fewer editions and an innovative new core-based licensing model to replace the per-processor model that we've all been enjoying up till now. I have been in this game long enough not to be overly surprised at such changes, although at first glance, it seems inevitable that many customers will end up paying more to get the same features they have today, unless they respond to Microsoft's creativity with some of their own.

Up to now, under the existing per processor or Server/CAL model, it's been hard for companies like mine to justify the extra expense of Enterprise edition SQL Server. Firstly, it wasn't really necessary from a performance perspective. Standard Edition for SQL Server 2005 to 2008 R2 allows for OS-maximum memory and CPUs. For our medium-to-heavy workload servers, we were quite happy running Standard Edition on Windows 2003 or 2008 Enterprise Edition, 64-bit; this gave 64 GB of RAM and allowed us to max out on CPUs at no additional charge per non-physical processor.

Secondly, although there were many Enterprise features that I would love to have had, such as table partitioning, database snapshots, resource governor and data compression, there was never any single, feature that was so necessary that it couldn't be "compromised away" when the Enterprise bill was put on the table.

However, SQL 2012 Enterprise Edition brings with it one feature that may just be too compelling for compromise, and that is AlwaysOn Availability Groups. It seems to be the answer to a lot of my current distributed systems woes, providing not only high availability and disaster recovery but readable mirrors for reporting.

I admit, when I first saw the new licensing model, it seemed that my readable replicas would remain forever a dream, unless I could sell the idea of spending a whole lot more money to get them. Now, however, I'm starting to think of the trade-offs that might make it feasible. I would have to push for higher speed processors with fewer cores, or a move more to a virtual world. The cost is still going to be high, but at least there is more hope that it won't be immediately dismissed as too preposterously expensive. And it will mean that AlwaysOn, and of all the other Enterprise features that I have wanted desperately to implement in the past, will now be available to me.

These are the thoughts I am having before the launch has even taken place. I am already thinking creatively on the sales pitch!

Rodney Landrum (Guest Editor)

Total article views: 222 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Top Ten Features of Enterprise Manager

SQL Server 7 revamped Enterprise Manager to be an MMC snap in with many more capabilities and functi...

BLOG

Tabular Model

One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The T...

ARTICLE

Poor Man's Enterprise Feature - Lock Pages in Memory

Enable Lock Pages in memory on Standard edition was ONLY an Enterprise feature until now. Read this ...

FORUM

Enterprise Edition SQL Server 2005 Performance issue on Multi Processor Server

Upgrade from single processor to 2 processors

FORUM

SQL Server Dual Processor

SQL Server 2000 Dual Processor /SQL 2005 Install

Tags
database weekly    
editorial    
licensing    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones