I too have a crippling dual CPU workstation hoarding habit. Single thread performance is usually worse than enthusiast consumer desktops, and gaming performance will suffer if the game isn't constrained to a single NUMA domain that also happens to have the GPU being used by that game.
On the other hand, seeing >1TiB RAM in htop always makes my day happier.
Personally I use eBay and find the most barebones system I can, then populate the CPU+RAM with components salvaged from e-wasted servers. There are risks with this, as I've had to return more than one badly-bent workstation that was packed poorly.
---
So the Dell Precision T7920 runs dual Intel Scalable (Skylake) and has oodles of DIMM slots (24!), but you'll need to use a PCIe adapter to run an NVMe drive. FlexBays give you hot-swappable SATA, SAS too but only if you're lucky enough to find a system with an HBA (or add one yourself). But if you manage to salvage 24x 64GB DDR4 DIMMs, you'll have a system with a terabyte-and-a-half of ECC RAM - just expect to deal with a very long initial POST and a lot of blink codes when you encounter bad sticks. The power supply is proprietary, but can be swapped from the outside.
The T7820 is the single-CPU version, and has only 6 DIMM slots. But it is more amenable to gaming (one NUMA domain), and I have gifted a couple to friends.
If you're feeling cheap and are okay with the previous generation, the Haswell/Broadwell-based T7910 is also serviceable - but expect to rename the UEFI image to boot Linux from NVMe, and it's much less power efficient if you don't pick an E5 v4 revision CPU. I used a fully-loaded T7910 as a BYOD workstation at a previous job, worked great as a test environment.
Lenovo ThinkStation P920 Tower has fewer DIMM slots (16) than the T7920, but has on-motherboard m.2 NVMe connectors and three full 5.25" bays. I loaded one with Linux Mint for my mother's business, she runs the last non-cloud version QuickBooks in a beefy network-isolated Windows VM and it works great for that. Another friend runs one of these with Proxmox as a homelab-in-a-box.
The HP Z6 G4 is also a thing, though I personally haven't played with one yet. I do use a salvaged HP Z440 workstation with a modest 256GB RAM (don't forget the memory cooler!) and a 3090 as my ersatz kitchen table AI server.
fooker|2 months ago
snerbles|2 months ago
---
So the Dell Precision T7920 runs dual Intel Scalable (Skylake) and has oodles of DIMM slots (24!), but you'll need to use a PCIe adapter to run an NVMe drive. FlexBays give you hot-swappable SATA, SAS too but only if you're lucky enough to find a system with an HBA (or add one yourself). But if you manage to salvage 24x 64GB DDR4 DIMMs, you'll have a system with a terabyte-and-a-half of ECC RAM - just expect to deal with a very long initial POST and a lot of blink codes when you encounter bad sticks. The power supply is proprietary, but can be swapped from the outside.
The T7820 is the single-CPU version, and has only 6 DIMM slots. But it is more amenable to gaming (one NUMA domain), and I have gifted a couple to friends.
If you're feeling cheap and are okay with the previous generation, the Haswell/Broadwell-based T7910 is also serviceable - but expect to rename the UEFI image to boot Linux from NVMe, and it's much less power efficient if you don't pick an E5 v4 revision CPU. I used a fully-loaded T7910 as a BYOD workstation at a previous job, worked great as a test environment.
Lenovo ThinkStation P920 Tower has fewer DIMM slots (16) than the T7920, but has on-motherboard m.2 NVMe connectors and three full 5.25" bays. I loaded one with Linux Mint for my mother's business, she runs the last non-cloud version QuickBooks in a beefy network-isolated Windows VM and it works great for that. Another friend runs one of these with Proxmox as a homelab-in-a-box.
The HP Z6 G4 is also a thing, though I personally haven't played with one yet. I do use a salvaged HP Z440 workstation with a modest 256GB RAM (don't forget the memory cooler!) and a 3090 as my ersatz kitchen table AI server.