SQL Server 2008 R2 rules the roost

published: 2014-11-03 13:30

From time to time we report on what versions of SQL Server are being used. This data is generalised, anonymized and aggregated from various sources within the RockSolid SQL business, and we feel this data is representative of the general SQL Server marketplace (although we haven’t tried to confirm/prove this). The purpose of this is to help our customers understand where their environment sits in terms of the broader market, understand what skills investment is required and help pick trends.

The latest results on what version SQL Server is being used is below, and without question SQL Server 2008 R2 holds the largest share of any current installed version, 45% in fact. This is up from 41% from 2013 and from 24% in 2012. Other results include:

  • SQL Server 2014 is only at 1% of current installs
  • SQL Server 2012 has risen from a measly 2% in 2013 to 17% in 2014.
  • SQL Server 2008 fell from 19% in 2013 to 14% in 2014
  • SQL Server 2005 fell from 27% in 2013 to 18% in 2014.

And the old battler, probably one of the oldest legacy pieces of Microsoft software still in widespread use, now in its 14th year since release, SQL Server 2000 fell from 11% in 2013 to just 5% in 2014.

So what does this all mean? Well put simply:

  • Customers are finally upgrading older versions (SQL Server 2000, 2005 and 2008) of SQL Server, and generally taking these old versions up to the latest releases, being SQL Server 2012 or SQL Server 2014.
  • However, customers see SQL Server 2008 R2 as an adequate release and are not necessarily seeing the benefits of migrating from SQL Server 2008 R2 to the later SQL Server 2012 or SQL Server 2014 versions.
  • New implementations are generally preferring SQL Server 2012, with the benefits of SQL Server 2014 not necessarily being articulated to an extent powerful enough move customer’s standard install from SQL Server 2012 to SQL Server 2014.

Customers will upgrade over time, but it is likely that 2012 and 2014 may largely be skipped over as the focus on upgrading SQL Server 2008R2 will likely come into frame after the next version of SQL Server is already released.

About RockSolid: RockSolid SQL is an innovative software and services company. They are the makers of the RockSolid SQL Server management solution and providers of SQL Server DBA support services. They directly manage over 17,000 SQL Server databases via their DBAaaS offering, and their RockSolid technology manages an estimated 40,000 SQL Server databases.

RockSolid Automation Platform

Related News

SQL Server 2014 to be skipped for 2016?

SQL Server Disaster Recovery VS. High Availability (Update)

Low cost backup and recovery for SQL Server Express POS terminals

SQL Server Cluster Instance failing over from Primary Node to Secondary with no specific error

The high cost of SQL Server under management