none
Determining if a server is 32 bit vs 64

    Question

  • 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

    Monday, June 11, 2007 7:38 PM

Answers

  • There are several separate pieces of information you need to gather.

    • CPU 32bit or 64bit?
    • CPU x32, x64, ia64?
    • OS Win2000, Win2003?
    • OS 32bit or 64bit?
    • SQL Server 32bit or 64bit?

     

    I think that the way to go about this is with a WMI script. (Not my forte -I would ask someone else to write it.)

    Monday, June 11, 2007 11:18 PM

All replies

  • There are several separate pieces of information you need to gather.

    • CPU 32bit or 64bit?
    • CPU x32, x64, ia64?
    • OS Win2000, Win2003?
    • OS 32bit or 64bit?
    • SQL Server 32bit or 64bit?

     

    I think that the way to go about this is with a WMI script. (Not my forte -I would ask someone else to write it.)

    Monday, June 11, 2007 11:18 PM
  • Hello Kyle

     

    Try this...

     

    http://www.vmware.com/download/ws/drivers_tools.html

     

    This is a utility that checks the processor for 64-bit compatibility.  It is 6kb in size and gives you a basic "is or is not compatible" window message when it is ran on the target computer.

     

    -Clayton

     

    Friday, September 28, 2007 9:44 PM
  • Where do you look in SQL Server Enterprise to view if it is a SQL server 32-bot or 64-bot?

     

    Thanks

     

    Monday, July 14, 2008 12:38 PM