I despair a little bit and want to give up.
All sources tell some different things and I have not the knowledge to have an overview.
I compared the `ASRock Rack X470D4U` and the `ASRock X570 Pro4`. Both seem to support ECC, but only the X570 supports DDR4-3200. And that is recommended for the Ryzen 7 3700X. But what does "recommended" mean? Do I have a bad experience when using only DDR4-2666? (My main PC with a i7-7700K runs well and I never checked the speed of CPU to MB to RAM ... ok, sometimes it is a little slow, but that also can be the OS.)
I tried to create two build in order to compare and I came up with these:
The AMD build from above, slightly modified.
Pros when compared with the Intel Xeon build: more power (stronger CPU), also less needed energy/power, lower power supply needed, cheaper
Cons when compared with the Intel Xeon build: No idea if ECC will work, RAM must be overclocked
A new Xeon build, with all your recommendations and new knowledge :
Pros when compared with the AMD build: Gigabyte motherboard (for "Initial Display Output" BIOS setting), guaranteed working ECC, 2x Ethernet for link aggregation
Cons when compared with the AMD build: less power than the AMD build (weaker CPU), more power/energy needed, bigger power supply (I did not find any 500 Watt with the extra 4-pin ATX for the motherboard - why?), more expensive
To 2:
What build would you recommend for replacing two main workstation in the next months (Linux and Windows VMs), some docker container (websites, database, plex, ...), build processes and a little gaming?
Can I basically compare the numbers of the CPUs and motherboards, or are there specifications that are more important than numbers? (Functions, that for example only a Xeon has, ...). Because I have the feeling, that the AMD build is more a desktop build and the Xeon is more a server build. But why do I have that feeling? And why is it so hard to get a Ryzen with the correct RAM with the needed Speed and ECC all together?
Sry for my bad knowledge in this field. I really try my best, reading and learning as fast as I can.
And of course, thank you for all your time.