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.

blog comments powered by Disqus

 

Banner


$15M Global Learning XPRIZE
25/09/2014

A crowdfunded challenge from XPRIZE to create tablet-based open source software to provide basic education in reading, writing and arithmetic aims to bring literacy to over 250 million children around [ ... ]



Fear And Loathing In the App Store 8 - Apple Takes Down Innovative App
08/10/2014

Programming into the unknown - it is what keeps us all going. The idea that with nothing but some code we can do something that hasn't been done before. In the old days what you did was between you an [ ... ]


More News

Last Updated ( Monday, 09 September 2013 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.