
Sizing a dedicated database server: memory first, then disks
Most database performance problems are a working set that no longer fits in memory, or a commit that waits on a slow flush. How to measure both, how much RAM and what kind of disk to buy, where the CPU matters, and how to lay out replicas and backups.




