THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rick Heiges

News about SQL Server and the SQL Server Community

Survey says......

Last Friday, I did a webcast for Windows IT Pro on Moving to 64-bit with a special focus on SQL Server.  It is also most likely cross listed with SQL Magazine webcasts.  Here is the link.

During this webcast, I polled the attendees (about 140) on some issues that you may find interesting.  Here are the results:

Do you have SQL Server 2005 running in production in your organization?

No – All production servers are SQL 2000 or earlier (59.5%)
Yes – We have 1 or 2 systems “Live” (34.7%)
Yes – The Majority of our production systems are SQL 2005 (8.8%)
Yes – We are completely switched to SQL 2005 (0%)

Do you have SQL Server running in a 64-bit environment?

Yes – We have at least one production system using SQL Server 2000/2005 64-bit (26.5%)
Yes – We have a majority of our systems on SQL Server 2000/2005 on a 64-bit platform (2.4%)
No – That’s why I am here (71.0%)

Are you running Windows Server 2003 Enterprise Edition in your environment?

- At lease one server is Windows Server 2003 Enterprise Edition is running in Production (38.6%)
- A majority of our production servers are Enterprise Edition of Windows Server 2003 (28.7%)
- A majority of our production servers are Standard Edition of Windows Server 2003 (23.7%)
- We only run Windows Server 2003 Standard Edition in our production Environment (4.9%)
- We are still on Windows 2000 or earlier (3.9%)

Do you currently use SQL Server for BI in your environment?
- Yes (55.2%)
- No (40.9%)
- Not Sure (3.8%)

Do you currently have many "small/medium" SQL Servers running in your production enviornment?

- Yes (78.6%)
- No (18.4%)
- Not Sure (2.9%)

Has this session helped to shed light on the benefits of 64-bit technology?

- Yes (89.7%)
- No (3%)
- Not Sure (7.1%)

Think about a specific project that you are working on.  Which 64-bit platform are you leaning towards?
- X64 (69.6%)
- Itanium (16.1%)
- Neither – I am sticking with 32-bit (0%)
- Not Sure (14.1%)

After examining these results, it would appear that the benefits of 64-bit technology is being considered seriously by most databse professionals.  The x64 platform seems to be the popular choice at this time.SQL Server 2005 has close to 50% penetration in this survey's respondents' production environment - not even a full year after RTM.  But, there are still many systems that have not been upgraded yet.


Published Thursday, October 5, 2006 8:54 AM by RickHeiges

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



drsql said:

Nice job!  I enjoyed your webcast a lot and it cleared up a good deal about the differences between the two 64 bit platforms.

Thanks for posting the poll answers, since they did not show up on the recorded version of the presentation (too bad they can't keep the polls either live!)  One request, can you post your links too?  
October 5, 2006 8:27 AM

RickHeiges said:

October 6, 2006 6:41 AM

Leave a Comment


This Blog


Privacy Statement