Determining if a server is 32 bit vs 64

  • Kyle Schlapkohl

    SSCrazy

    Points: 2463

    Is there a quick and easy way to figure out if a server is 64 bit or 32 bit?  I have been looking and cannot figure out an easy way.  If there is a script that will figure it out could you please tell me.  I am a DBA and manage over 100 servers and need a fast and easy way to figure this out.

    -Kyle

  • Anders Pedersen

    SSChampion

    Points: 11410

    Could allways parse out the @@version information, right after the version number it will list the architecture it is for (like on mine says Intel X86).

     

     

  • Anders Pedersen

    SSChampion

    Points: 11410

    So this bugged me, had to be a better way.

     

    exec

    master.dbo.xp_msver

    Index = 4 is for the platform, in mine says NT Intel X86.  I don't have a 64 bit server up and running SQL on it, so can't verify what this would say if on a 64 bit.  Anyone?

  • EdVassie

    SSC Guru

    Points: 60274

    Look in the system Environment variable PROCESSOR_ARCHITECTURE. 

    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

  • Anders-446552

    Valued Member

    Points: 71

    Maybe this can help:

    http://www.stata.com/support/faqs/win/64bit.html

  • Greg Edwards-268690

    SSC-Insane

    Points: 20586

    The stored pocedure gives all the info you may need. I assume you would be interested that SQL Server is 64 bit if running on x64 bit platform. Someone could run 32 bit on x64 bit OS.

    GE

    1 ProductName NULL Microsoft SQL Server

    2 ProductVersion 589824 9.00.2153.00

    3 Language 1033 English (United States)

    4 Platform NULL NT AMD64

    5 Comments NULL NT AMD64

    6 CompanyName NULL Microsoft Corporation

    7 FileDescription NULL SQL Server Windows NT - 64 Bit

    8 FileVersion NULL 2005.090.2153.00

  • Kyle Schlapkohl

    SSCrazy

    Points: 2463

    Thanks you for all your help.  My issue has been resolved.

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

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