SQL Server Performance Forum – Threads Archive

SQL cluster 64 bit

Hi, I am getting ready to implement a 2 node active/active SQL cluster. I believe I understand everything in order to setup the cluster, but I also want to run the 64 bit version of SQL. Here is my real question. I will have 32 bit Foxpro applications accessing this cluster via odbc’s. Will this still work ok if the SQL complex is 64 bit? Will I notice a performance gain or am I wasting my time? Any help would be much appreciated.

I don’t know of any reason why this will not work. If you are having performance issues with your Foxpro application, and the cause it because it is a FoxPro application, performance probably won’t increase. The only reason you might see a performance boost with your FoxPro application is if the performance issue is caused by SQL Server hardware-related bottlenecks, and if the new hardware allows SQL Server to run faster. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

Ok, I think I’m ok with 64 bit, but let me add this. I’m not trying to make the foxpro apps themselves run better, but I’m hoping the queries they pass to the cluster, process more efficiently in the 64 bit environment. Make sense?

The queries won’t run any more efficiently because of 64-bit. All 64-bit buys you is access to larger amounts of memory. If you are having performance issues with your queries, then they need to be tuned. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

Have you ever had issues with these 32 foxpro application in the non-clustered base environment? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

No, none whatsoever. Just looking for ways to increase performance has the load increases on our SQL complex.

]]>