To start with I’m not going to begin to argue that my poll is of adequate industry sample size for a true adoption rate but there is a definite trend in the results.
- 51% of the people who voted indicated that they currently have no SQL Server 2008 instances running in production.
- 37% indicated that they have a quarter or less of their production SQL Server instances running on SQL Server 2008.
Combined that’s 88% that either have no instances or less than a quarter of their production instances on SQL Server 2008.
So what are some of the reasons for this?
- The stigma of Microsoft products and NEVER installing them in production until Service Pack 1 is released?
- The cost associated with an upgrade project?
- Too many 3rd party applications still don’t support SQL Server 2008?
- Too many Databases that are still on SQL Server 2000?
- The new features/functionality in SQL Server 2008 doesn’t warrant an upgrade at this time?
I’ve seen (and been involved in) arguements on most of these reasons in the environments I’ve been exposed to and support. Maybe it’s because I have been trying to do as much with SQL Server 2008 during all the CTP releases, RC0, and RTM that I feel more comfortable and confident with SQL Server 2008 than when SQL Server 2005 first came out.
Steve Jones posted an article in March of 2008 (almost a year ago) about the adoption rate of SQL Server 2005. The poll that he ran was much more indepth than my “mini-snapshot” view of the world but the two questions that I want to draw attention to are:
1) Which SQL Server platforms are you running?
v4.2 – 0%
v6/6.5 – 1% (9/610)
v7 – 12% (73/610)
v2000 – 92% (563/610)
v2005 – 59% (357/610)
2) Will you upgrade to SQL Server 2008 within a year of its release?
Yes – 32% (198/610)
No – 68% (416/610)
So this was March of 2008. Almost 3 years after SQL Server 2005 RTM was released only 59% of the people polled indicated that they have SOME level of SQL Server 2005 adoption and only 32% of people polled indicated that they plan on upgrading to SQL Server 2008 within the first year of it’s release. With SQL Server (planning on) releasing new versions every 2 years and support ending on versions that are more than a version old something has to give. Will adoption of the new versions happen sooner? Will companies run on non-supported versions of SQL Server?
I don’t want to become a “poll-whore” so please feel free to comment as to your experiences and reasoning for upgrading or not upgrading to SQL Server 2008 as well as if you think in the future that the adoption of a new version will happen quicker than what we’ve seen with SQL 2005 and SQL 2008 to date.