Post reply

Does SQL 2005, 2008, 2008R2 install different files/DLLs based on Intel or AMD processors?

  • December 19, 2011 at 12:49 pm

    #253676

    Hello Everyone,

    I'm looking at getting an answer to this simple question. When installing SQL 2005, 2008 or 2008R2 does different files/DLLs/etc. get installed based on the processor type (Intel or AMD)?

    Simple enough?

    Like to hear your thoughts.

    Thanks,

    Rudy

    Rudy

  • December 19, 2011 at 3:24 pm

    #1423319

    It should not and I'm 99% sure it does not.

    I don't have a reference to that, but you could easily find out comparing two installations.

    -- Gianluca Sartori

  • December 19, 2011 at 3:34 pm

    #1423325

    I am 99% sure the answer is no.. 32 vs. 64 yes, many different. AMD 32 vs. Intel 32, don't believe so.. AMD 64 vs. Intel 64, don't believe so. Bot sure why this is important though..

    CEWII

  • December 20, 2011 at 7:22 am

    #1423637

    Thank you all for the information.

    I reason for the strange question is that our server team was to move several WMWare ESX servers from our current AMD system to a new Intel system. Now I'm not sure how the HAL on the OS will handle the change of advance feature of the different chip sets. My task is to see if SQL will have a problem.

    Even MS support says that the SQL server installation will be fine, but have no documentation that states this and it appears there is nothing in the wild (internet) that supports this answer. My fear is that will have have issues later on and MS support will tell me to reinstall the OS and SQL server. That would be no fun.

    Thanks for taking time to answer my question 🙂

    Rudy

    Rudy

  • December 20, 2011 at 8:24 am

    #1423667

    I was guessing it was something like this.. As far as SQL is concerned I don't see it being a problem.. The OS should be ok too but that is a point where I think you'll see the most changes, but even then I think you'll be ok.

    CEWII

  • December 21, 2011 at 3:27 am

    #1424113

    I agree with Elliott. Once you have the OS running, then SQL Server should neither know or care if the processor is AMD or INTEL.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • December 21, 2011 at 4:07 am

    #1424126

    There are currently 3 versions of the SQL binaries and there will be differences between each of these files. There versions will be the same but there will be fundamental compilation differences.

    i64 / x86 / x64

  • December 21, 2011 at 4:08 am

    #1424127

    To follow up. The virtual machine CPU should be handled transparently to the OS. All of this is handled and emulated by VMWare.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply