We're upgrading to SQL Server 2005 and when the Network Administrator asked us if we wanted 64bit editions of windows and SQL Server 2005 versus the 32bit versions, and there was no price difference we said sure.



However, I stumbled across an article that makes me wonder if that was a smart idea. Should I be worried? or does the 64bit edition of SQL Server just utilize the 64bit architecure for better performance while everything else (databases, stored procedures, views, etc) stay the same?

You probably do no want to use 64-bit.  It may in many cases slow things down.  If you have a high number of long data type operations, then 64-bit is the platform for you.  But if integer is pretty much where you live, then it will take twice as many operations on a 64-bit platform than it would on a 32-bit platform.  Additionally, you are going to fight one version and driver issue after another.  Once you finally get it working the frustrations should go down, but I do not recommend 64-bit OSs or environments unless you know that you have a need for the long register calculations.

If you want a pleasant life and experience then go with the 32-bit version

Ok....



What about running 32bit apps on 64bit windows? Same advice?

Hi Trent.

Do you mean to avoid even the 64-bit processors? It's getting hard to find the 32 bits ones.

Is it alright if I install only 32-bit applications on it?

I think we just started a new server in the wrong way here, then.

This is going to be the root of your problems.  You are better off running a 32-bit OS and any subsequent applications. 

I am saying it is best to avoid 64-bit Operating Systems...this is where you generally have all of the issues.  If you are using AMD then most of their processors support either platform.

Unless you have a specific need for a 64-bit OS and environment, you are better off going 32-bit.  Most times people think of 64-bit and assume it will be bigger, better, and faster.  This is not always the case...one thing is for sure...it will consume more resources, take longer to setup, and be a frustrating experience when loading most applications .  Don't get me wrong, there is DEFINITELY a need for a 64-bit environment, but many times it is implemented when it is not necessary.

Thanks Trent. Guess I have some research/thinkin' to do.