Showing posts with label 64-bits. Show all posts
Showing posts with label 64-bits. Show all posts

Tuesday, February 14, 2012

Differences between SQL Server 2005 x64 vs X86?

Hi there,

I'm trying to find what are the main differences between SQL Server 2005 64-bits and 32-bits. So far, I've found some articles about TPC-C performance but I would like to know some response time or execution time of a batch or SSIS packages.

Any information about this 2 versions is appreciated.

Thanks!

Here are some articles that you may find interesting:

http://www.microsoft.com/sql/editions/64bit/default.mspx

http://www.microsoft.com/sql/techinfo/whitepapers/advantages-64bit-environment.mspx

64-bit does not automatically mean better performance. The only way to get actual response time of your application is to test on the 2 different platforms. Every application will be a different so it is impossible to say how much better or worse it will be on 64-bit versus 32-bit.

Hope this helps,

Peter Saddow

|||Hi Peter,

Thanks for the links, I had already read those articles. The second one was the most relevant and I'm testing right now my application on SQL Server 2005 x64 and it's not performing better :(. So you were right, it depends on the application.

Once again, thanks for your reply.