SQL Server - Mostly Out Of Date
Written by Kay Ewbank   
Monday, 09 September 2013

A survey of SQL Server instances has found that more than half don’t have the most recent service pack installed and that an even larger proportion are running versions of SQL Server that are no longer supported.

The survey was initiated by Paul Randal, CEO of SQLskills.com and reported on his blog. He collected results for 3085 SQL Server instances from several hundred respondents then analyzed the results to worked out what release number and versions the build numbers corresponded to. His shocking revelations are:

51% of all instances in the survey are out of date, by at least not being on the latest SP build, and 53% of all instances in the survey are unsupported.

The statistics, based on 3085 SQL Survey instances are summarized in this table:

 

Release Instances

Survey
%

 Out-Of-Date

%

Unsupported

%

7.0 1 0.03  100.00  100.00
2000 164  5.32  82.93  100.00
2005 1285  41.65  67.08  67.08
2008 394  12.77  41.12  41.12
2008 R2 1058  34.29  43.48  43.48
2012

182

 5.90  24.73  0.00

 

Less than 6% of the respondents to the survey are running SQL Server 2102 and even a quarter of these don't have the most recent service pack installed. This raises lots of questions. Randal speculates that there are reasons why companies stay with older unsupported versions of SQL Server, in particular where they are running a third party application that isn’t certified on new versions. However, deciding not to install a service pack leaves the server open to attack from known weaknesses.

It’s interesting, but perhaps unsurprising, that 41 per cent of the instances are still running on SQL Server 2005; the performance leap from 2000 to 2005 was substantial, but the subsequent performance gains with 2008, 2008 R2 and even 2012 aren’t nearly as impressive, and if you’re not using the new features, there will be many administrators and developers thinking along the lines of ‘if it’s not broke, don’t fix it’. However, given the fact that support for 2005 has ended, and support for 2008 and 2008R2 is in the process of ending, this does mean that over 50 per cent of the installations are running without support from Microsoft.

As Paul Randal says, while there are many reasons to still be running an older version of SQL Server, at least be running the most recent Service Pack or Cumulative Update if you’re able to!

 

More Information

More than half of all SQL Server instances are out-of-date and unsupported!

Related Articles

SQL Server 2012 Launched

SQL Server 2012 SP1 CTP

SQL Server 2008 SP 3

Pick of the Shelf - SQL Server 2012 Books

 

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

kotlin book

 

Comments




or email your comment to: comments@i-programmer.info

 

Banner


Geoffrey Hinton Shares Nobel Prize For Physics 2024
08/10/2024

with John Hopfield, for "foundational discoveries and inventions that enable machine learning with artificial neural networks."



A Turing Machine In LEGO
06/10/2024

A Turing Machine is one of those abstract ideas that is much easier to undertand if you can see it working. Now there's a proposal on the LEGO Ideas site for a Working Turing Machine. Lend it your sup [ ... ]


More News

Last Updated ( Monday, 09 September 2013 )