Tuesday, March 6, 2012

64bit or 32bit?

I want to get SQL Server 2005 for a clinic with 25 user but I am not sure if I should go for the 32bit or 64bit.. what's your recommendation? and why?

You are going to need to provide much more information than that before the question can be answered. However in general if your app is CPU or IO bound moving to 64 bit will not help, if it is memory bound it likely will(but not for sure).|||Clinic with 25 users data can be handled on a 32bit edition without any issues, as recenlty I have had setup of SQL 2005 32 bit on Win2k3 server with 8gb ram etc. without any issues. As referred if the application you are using has any specific requirement for 64 bit then you can consider in this case, it will be better if you are able to explain such requirements.|||

If you are getting new hardware, then I recommend getting 64 bit hardware and 64 bit SQL Server. There will be a longer 'service life' with 64 bit, and you don't know now how your needs will change over the lifecycle.

No comments:

Post a Comment