Last week I kicked off a survey asking what is the oldest version of SQL Server you have in production.
Here are the results:
I’m actually quite surprised. While I expected to see a sizable percentage of businesses still with SQL Server 2000 in production, I didn’t expect it to be almost half of all respondents – that’s massive! And 9% of businesses have SQL Servers *older* than SQL Server 2000. Although we’ll do performance troubleshooting on SQL Server 2000 (and it takes more time because of the lack of DMVs), we won’t touch anything older.
Last year I wrote a post You guys still use SQL Server 2000? Really? where I listed some of the reasons why people are stuck on SQL Server 2000 for some systems, with some client examples I knew of. SQL Server 2000 was a really solid release and I think it will be around for some time to come.
Here’s the kicker though, Extended Lifecycle Support ended for SQL Server 2000 on April 9th, 2013 (see here for all the details). And the hardware those SQL Servers are running on have to be out of warranty, or close too it, as well (Edit: unless the instances are virtualized, of course). I’d be getting really twitchy about wanting to upgrade the hardware and SQL Servers for those systems where there’s nothing major holding me back. We’re finding a lot of clients asking for upgrade help from SQL Server 2000 and 2005 due to the licensing gotchas with SQL Server 2012 and the ease of buying over-powered hardware that can’t be used without shelling out even more money for unneeded licenses.
I think that if I re-run this survey in another year, the results will be quite different as businesses realize the risk of running an unsupported version and finally upgrade.