If E3-1285 v6 supports a maximum of 64 GB of RAM, does using a dual socket motherboard increase max memory? I guess not, but would like to know the reason. My logic says that if RAM is shared, both processors should be able to address all available RAM and thus, it will also be limited to 64GB. Any technical explanation for this?
In modern CPUs the memory controller is integrated directly into the CPU, whereas in former times memory was accessed by the CPU over a bus system. The bus system had the advantage that memory access was uniform, which is still the case in single-socket CPUs.
Now, entering dual-socket systems, each CPU has dedicated local memory and the memory of the other CPU can be accessed indirectly over QPI which is in simple words a link between the two CPUs. This is called NUMA ( non-uniform memory access ).
Well, putting things together. If you have a second CPU you can increase the total amount of memory of your system, but you also need a CPU that is capable of running in dual-processor mode. IIRC the E3 series is not dual-socket capable, E5 is dual-socket capable and E7 quad-socket capable.
First of all, the E3-1285v6 does not support multi-socket, so to increase the number of CPUs in the system you'll need a different CPU.
While AMD and Intel CPUs in long-mode use 64-bit pointers, the CPUs available today are limited to 48 bit. Thus it is possible to address up to 256 TB of memory and every x86_64 compatible CPU can address that amount of memory.
However, there is another limitation: The memory controller integrated into the CPU. That memory controller has a limited number of channels (in case of your CPU: 2), which means that it can talk to two memory modules simultaneously. The channels can alternate between multiple modules (usually 2), so you can usually connect two modules per channel which totals to 4 modules in your case.
If you have a multi-socket board with multiple CPUs installed you will have one memory controller per CPU, so in the end you double the physical installable memory (which is not really related to addressable memory) by installing a second CPU.
If E3-1285 v6 supports a maximum of 64 GB of RAM, does using a dual socket motherboard increase max memory?
Yes using multiple CPUs does increase the maximum memory, however your CPU does not support multiple socket motherboards.
A fellow told me to try and build a Xeon system with integrated GPU (for openCL means) and 128 GB... and it is simply impossible :-(
Indeed, the low end (socket 115x) parts have the option of integrated GPUs (presumably because they are derived from the same basic designs as the mainstream desktop parts) but they don't have multi-socket support and they have a memory controller that only supports four modules (two channels with two modules each) of unregistered memory. With current technology that limits you to 64GB.
The higher end parts have better memory controllers with more channels and support for memory types that allow more and larger modules per channel (512GB per socket is doable) and in some cases support for multi-socket configurations but they lack the integrated GPUs.