SQL Server Performance

SQL cluster 64 bit

Discussion in 'SQL Server Clustering' started by cnikirk, Feb 24, 2005.

  1. cnikirk Member

    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.
  2. bradmcgehee New Member

    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
  3. cnikirk Member

    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?

  4. bradmcgehee New Member

    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
  5. satya Moderator

    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.
  6. cnikirk Member

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

Share This Page