How would one be able to tell if the processor in their
SQL server, server is a 64-bit chip or not?
I know this sounds like a silly question but due to the
nature of corporate life, I need to figure this out from a remote connection.
The server is in a different location.
In the Device Manager you can right click > properties of the CPU. Then under the Details tab you can see the device id properties which will tell you the family, model, stepping and x86 for 32 bit or x64 for 64 bit.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
This still may not be the information you want. That will tell you if the processor is 32 or 64 bit, but it won't tell you if the OS is 32 or 64 bit. It is extremely common to run 32 bit OS on a 64-bit chip.
The device manager will show its platform and you can get the windows os info from either right clicking on the my computer icon or menu item and selecting properties or you can run the mssysinfo like previously posted.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
The processor is the CPU and that can be got from both on most newer systems from the my computer properties display. That is the processor's bit depth either 32 or 64. Now you also can have Windows Operating System designed and optimized for either 32 or 64 bits too. The ultimate would be to have a 64 bit processor running 64 bit Windows.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Yes I am talking about the system properties but not all versions of windows will display the same indepther info. Some will display less details forcing you to look into the Device manager.
I was saying for the ultimate (fastest and most powerful) you would have them both running 64 bit.
You can have any combination of 32 on 32 or 32 on 64 or 64 on 32 or 64 on 64. etc.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Yes I am talking about the system properties but not all versions of windows will display the same indepther info. Some will display less details forcing you to look into the Device manager.etc.
Yes, I agreed with you. I'm really experienced this on Linux versions.
Is it ok 32 on 64. Still I'm worried about that. Because how 312 bits interact with 64 bits data, etc
“victory breeds hatred, the defeated live in pain; happily the peaceful live giving up victory and defeat” - Gautama Buddha
In the Device Manager you can right click > properties of the CPU. Then under the Details tab you can see the device id properties which will tell you the family, model, stepping and x86 for 32 bit or x64 for 64 bit.
ACPI\GENUINEINTEL_-_X86_FAMILY_6_MODEL_15\_0
Is it possible to have an X86 response, but really be a 64 bit processor?
HACK, I have been told, that, no, I cannot just pick up the phone and call someone.
you can not only not run a 64-bit OS on a 32-bit processor, but the install program for vista and xp actually checks before it runs and won't let you even install it in the first place.
The only reason you can run 32 bit on a 64-bit chip is the chip also has a 32-bit mode. If you are running a 64-bit OS, all 32 bit programs you run execute in a virtual processor. xp & vista use the WOW (windows on windows) to do this. The 64-bit version that lets you run 32 bit programs is called wow64.
Robdog, i don't know what an itamium would result on that check. The x64 is the athalon result and i know for a fact the install disk has a separate directory for each supported processor. So it is possible the result with the check will be different.
Well back when I got my cpu it was realeased just a few months prior and the documentation was very limited (got cpu directly from Intel). I had looked it up and the little "EM64T" designation and didnt have this specification...
Intel® EM64T requires a computer system with a processor, chipset, BIOS, operating system, device drivers and applications enabled for Intel EM64T. Processor will not operate (including 32-bit operation) without an Intel EM64T-enabled BIOS. Performance will vary depending on your hardware and software configurations.
It only stated "..supports extended memory technology with blah, blah, blah..."
So I remember asking Kleinma about it too and I vaguely remember opting between installing 32 or the 64 bit Vista RTM.
Im hopefuly going to install Vista 32 bit on my other P4 2.8 system tonight so maybe soon I can back my stuff up to it and reload my x6800 with 64 bit vista. Just need to see if all drivrs are 64 bit now.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Well my system reports in the sysinfo "System Type: "X86 based PC" so I would guess thats the OS bit depth.
But the designation in my device manager shows x86
Last edited by RobDog888; Aug 1st, 2007 at 12:01 PM.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
i have code at home that reads the processor model number. Too bad i am at ex-wife's house. Anyway, using the processor model (like robdog got earlier) it should be possible to design a select-case in code that shows the processor bitdepth. Pretty well the only things that are 64-bit are itaniums, xeons (i think), core-2, and x64 series
i have code at home that reads the processor model number. Too bad i am at ex-wife's house. Anyway, using the processor model (like robdog got earlier) it should be possible to design a select-case in code that shows the processor bitdepth. Pretty well the only things that are 64-bit are itaniums, xeons (i think), core-2, and x64 series
As are Pentium D's.
And, if you can install some software, install CPU-Z, which can be found at http://www.cpuid.com/cpuz.php, look through the Instructions part of the main program, a 64-Bit Intel processor will report EM64T as an instruction set for 64Bit. With an AMD, it's obvious, Athlon 64's, are 64Bit, as are X2's, and of course Sempron 64's. All this information will be found within CPU-Z's main screen like the one below of my gf's PC: