SQL Server Version Usage - Real World Data

published: 2012-10-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.

One of the most interesting topics is one of the simplest. Which versions of SQL Server are being used in production, and what are the relative ratios between versions?

The graph bellow shows the breakdown of SQL Server usage in production today across our client base:

SQL Server Version Breakdown

Interesting facts

  • SQL Server 2000 still makes up 41% of our customers production SQL Server installations. This is an amazing statistic given than SQL Server 2000 is now over 12 years old.
  • SQL Server 2012 is just 1% of our customers production SQL Server installation. At the moment, customers are preferring to deploy SQL Server 2008 R2.

Of course these stats are very high level and should be taken with a pinch of salt, we will provide more detail in future posts. For example, while the stats show most instances are still SQL Server 2000, if we look at instances our customers call “key” or “critical”, almost all of these instances are either SQL Server 2008 or 2008R2. The majority of SQL Server 2000 instances are less critical and have not been upgraded yet because they just keep ticking along, doing their job day in and out.

But one key fact that has little room for debate is as follows.  SQL Server 2000 was the most significant and awesome release of SQL Server from Microsoft and has clearly stood the test of time. It is probably one of Microsoft’s greatest ever software releases.

RockSolid Automation Platform

Related News

Introducing the RockSolid Database Firewall

SQL Server 2014 to be skipped for 2016?

What Makes RockSolid Different?

SQL Server Disaster Recovery VS. High Availability (Update)

Delivering Database as a Service