4 ms·
From my point of view for typical modern bussiness workloads that necessiate large machines (ie. SQL RDBMS or something similar) only thing that you really care
by dfox 8y ago
From my point of view for typical modern bussiness workloads that necessiate large machines (ie. SQL RDBMS or something similar) only thing that you really care about is memory size. On the other hand many "legacy" mainframe workloads are significantly more CPU-bound because the software culture is simply different and brute force is often the way to go.
- mmt 8y ago> From my point of view for typical modern bussiness workloads that necessiate large machines (ie. SQL RDBMS or something similar) only thing that you really care about is memory size. That's my general impression, as well, but I have little enough (or inadequately broad) direct experience for that impression to be a strong one. I've also seen, second-hand (i.e. benchmarks, so not quite real-world) that cache and memory latencies (including inter-CPU/NUMA) can significantly affect OLTP performance. If that weren't true in practice, then the sheer bandwidth one can deliver from enough SSDs over PCIe rivaling a CPU's memory bandwidth would mean main memory size is much less relevant.