SQL Server Performance

bit version

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by zsamz, Jun 26, 2007.

  1. zsamz New Member


    Hi all
    I have windows 2003 R2 64 bit version of operating system. I have SQL server 2005. How do I check if the SQL server I have is 32 bit version or 64 bit version
    any help is appreciated
  2. satya Moderator

    SELECT @@VERSION

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. zsamz New Member

    I know that but does x86 means 32 bit? what it says for 64 bit?
  4. SmallBiz462 New Member

    It will say (X64).

    SB
  5. satya Moderator

    FYI, please note there are no 64bit tools so with usual 32bit management studio you would be able to perform the chores/

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  6. zsamz New Member

    Thanks for all the help
    I had 32 bit SQL server and is not compatible with 64 bit operating system. I am in the process of getting 64 bit version on SQL server 2005.
  7. joechang New Member

    who told you 32-bit SQL is not compatible with 64-bit OS
    whoever told you this is an idiot
    disregard any other advice from this person
  8. satya Moderator

    .. say what is the problem in accessing x64 OS here?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  9. zsamz New Member

    Microsoft will not support a 32 bit SQL server to 64 bit win 2003 server. that is what I was told.
    Also when I try to run the SQLdiag I could not run as SQLDiag is 32 bit which runs on 64 bit OS and also I have missing counter. this let me beleive that SQL server 32 bit is not fully compatible. any advice. until now I am running 32 bit sql server on 64 bit OS but we are in the process of changing it.
    Any advice is appreciated
  10. satya Moderator

    One of the Technet articles refers
    quote:A small number of features are not included in x64 Windows, including DOS, POSIX, 16-bit support, and a few legacy networking protocols no longer in active use. However, we do not expect most customers to be affected by these differences. Based on customer feedback, we expect the initial x64 usage scenarios for Windows Server 2003 to be databases, business applications, Terminal Server, Active Directory, Internet Information Services (IIS), and technical computing.
    See this KBAhttp://support.microsoft.com/kb/916950 for such hotfix on 32 bit, fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page