Monday, June 11, 2007 7:38 PM
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.
Monday, June 11, 2007 11:18 PMModerator
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.)
Friday, September 28, 2007 9:44 PM
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.
Monday, July 14, 2008 12:38 PM
Where do you look in SQL Server Enterprise to view if it is a SQL server 32-bot or 64-bot?