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