SQL Server Edition Usage - Real World Data

published: 2012-11-30 00:00

As you know from a previous post, we are supporting thousands and thousands of production SQL Server databases for many customers across all industries and markets. This gives us interesting insights into how SQL Server is being used. Our scale also allows us to undertake broad analysis which, we believe, can be extrapolated to give a reasonable picture of what the SQL Server world looks like across the board.

Recently we covered in this post, the relative usage of different versions of SQL Server. And in this post, we covered the relative sizes of SQL Server databases.

The graph bellow shows the relative use of the key editions of SQL Server in production today across our customer base:

SQL Server Edition Usage

* This graph excludes customers who are using Personal, Express, Desktop & Developer Editions of SQL Server.

So what can we learn from this?

  • Web is so under used considering its cost. I expect that many sites don’t understand the functionality & licensing of web edition yet.
  • Standard edition remains most popular. This reflects the traditional “box per app” model. With a focus on consolidation & virtualization, over time we expect the % of standard licenses to fall slightly.
  • Use of SQL Server Enterprise is strong. However remember from our previous post, only a very small % (source data) are using SQL Server 2012. Our jury is still out on how the licensing changes in 2012 impact the use of Enterprise.

The usual disclaimers about statistics and the margin of error etc when we extrapolate this out.

RockSolid Automation Platform

Related News

RockSolid SQL becomes part of UXC Eclipse, A CSC Company

SQL Server 2014 to be skipped for 2016?

SQL Server Disaster Recovery VS. High Availability (Update)

Top 10 SQL Server Patching Automation Benefits

Magnificent SQL Server Patching