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

Answer 1

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.)

Answer 2

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

 

Answer 3

Where do you look in SQL Server Enterprise to view if it is a SQL server 32-bot or 64-bot?

 

Thanks