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.

No comments:

Post a Comment