Question posted in 
I was wondering to install a server on my windows machine and came to know that it is best to install a 32bit version on a 64bit machine. Is it really required.
Why is it recommended?
I want to install it for study.
I was wondering to install a server on my windows machine and came to know that it is best to install a 32bit version on a 64bit machine. Is it really required.
Why is it recommended?
I want to install it for study.
2
Answers
Installing 32-bit software on a 64-bit machine is not recommended. No one with any credibility would make this senseless recommendation.
A major disadvantage of 32-bit software is that it cannot use more than 4GB of RAM, because memory addresses must fit into the word size of the software. This is a serious deficiency for a database server, which benefits from extra RAM.
I did consulting for a major company who was having database performance trouble. They were using Windows Server. They had been adding extra RAM DIMMs, having heard that RAM can be used to increase caching resources, but no matter how much RAM they added, it didn’t help.
I logged into their site and found they were using Windows Server 32-bit. They had been spending a ton of money on RAM, but their operating system could not see it.
I listened to the YouTube video you linked to, to hear the justification of the speaker. He seems to be saying that since Windows 64-bit is backward-compatible and can run 32-bit binaries, but the reverse is not true (Windows 32-bit cannot run 64-bit binaries), he thinks you should use 32-bit binaries because they will work on both architectures.
That’s bad advice.
The better advice is: Make sure you aren’t using Windows 32-bit.
Come on, it’s 2018. The days of 32-bit platforms is long gone.
It is definitely not required. I would say that it’s not even recommended. Any 64 bit machine will be able to run a 32 bit server, however, a 32 bit server will highly underutilize the processor, especially when performing complex or graphical operations