Post reply

Can some one tell me how to check whether the server is 32 bit or 64 bit....

  • June 22, 2009 at 11:23 am

    #132033

    Hi friends can any one tell me how to check whether the server is 32 bit or 64 bit?

    I have Standard Edition ,but I want to know whether is 32 bit or 64. I tried xp_msver, HKEY_LOCAL_MACHINE-->SOFTWARE-->microsoft-->MSSQL1-->SETUP , but there I couldn't find it.

    @@version was showing Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) , but how do I know it is 32 or 64..?

    Thanks,

    MC

    Thanks & Regards,
    MC

  • June 22, 2009 at 11:37 am

    #1013482

    @@version was showing Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) , but how do I know it is 32 or 64..?

    That is a common mistake because 32bits is named for the chip which is x86 so your server is 32bits.

    Kind regards,
    Gift Peddie

  • June 23, 2009 at 5:49 am

    #1013849

    K.. So you mean to tell Intel X86 means it is 32 bit, so incase of 64 how will it represent?

    Thanks,

    MC

    Thanks & Regards,
    MC

  • June 23, 2009 at 6:52 am

    #1013881

    only4mithunc (6/23/2009)

    K.. So you mean to tell Intel X86 means it is 32 bit, so incase of 64 how will it represent?

    Thanks,

    MC

    (X64)

  • June 23, 2009 at 7:20 am

    #1013898

    steveb (6/23/2009)

    only4mithunc (6/23/2009)

    K.. So you mean to tell Intel X86 means it is 32 bit, so incase of 64 how will it represent?

    Thanks,

    MC

    (X64)

    And (IA64) for Itanium 64 chip which has limited use but it is the first 64bits chip for the Microsoft platform.

    http://en.wikipedia.org/wiki/IA64

    Kind regards,
    Gift Peddie

  • June 23, 2009 at 8:07 am

    #1013957

    Ok.. thank you..

    Regards,

    MC

    Thanks & Regards,
    MC

  • June 23, 2009 at 6:32 pm

    #1014361

    only4mithunc (6/23/2009)

    K.. So you mean to tell Intel X86 means it is 32 bit, so incase of 64 how will it represent?

    Just for clarity:

    32-bit example:

    Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    64-bit example:

    Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    You can also get the distinction by running select serverproperty('edition'):

    32-bit:

    Enterprise Edition

    64-bit:

    Developer Edition (64-bit)

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • June 24, 2009 at 6:31 am

    #1014593

    K.. but select serverproperty will give the edition information only na? Like Enterprise/developer/ Standard/Express etc

    And I think except Express edition others can be 32 or 64 , so only with the result of SELECT SERVERPROPERTY we cant tell whether it is 32 or 64 na?

    Regards,

    Mithun

    Thanks & Regards,
    MC

  • June 24, 2009 at 6:58 am

    #1014618

    only4mithunc (6/24/2009)

    K.. but select serverproperty will give the edition information only na? Like Enterprise/developer/ Standard/Express etc

    And I think except Express edition others can be 32 or 64 , so only with the result of SELECT SERVERPROPERTY we cant tell whether it is 32 or 64 na?

    Mithun,

    Come on dude - I gave specific example output from two real servers to show you just that!!! :doze:

    'Na' is also not a word 😛

    Paul

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • June 24, 2009 at 11:43 am

    #1014814

    Coooolllll buddy.... 🙂 , thanks a lot.

    MC

    Thanks & Regards,
    MC

  • June 24, 2009 at 11:49 am

    #1014818

    K.. but select serverproperty will give the edition information only na? Like Enterprise/developer/ Standard/Express etc

    And I think except Express edition others can be 32 or 64 , so only with the result of SELECT SERVERPROPERTY we cant tell whether it is 32 or 64 na?

    Another thing to note Express comes in x86 binaries that can install in x64 because if you run the standard x86 binaries it will not install in Vista x64 WOW64. And 2008 all editions comes in both x64 and x86 and some editions comes in IA64

    Kind regards,
    Gift Peddie

Viewing 11 posts - 1 through 10 (of 10 total)

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