I'm the Infrastructure Architect at the company I work at, and in my free time (lol) I have been looking into what it would cost for a new physical host for to move our SQL DBs to.
Our main business app relies VERY heavily on SQL and is used by around 500 employees on average every day. The complication is that it must reference data going back to 2006, and some tables have 10's of millions of rows. We have "cleaned up" the database as much as we can without purging needed data, and while the DB isn't huge at only around 250 GB, it gets hammered all day, every day, and we've started seeing issues with other application functions that go on in the background which also leverage other SQL DB's. One of the processes pulls millions of rows of data, does compares, and then updates other tables, every night, for multiple DBs. We have been working with the application vendor to see if we can figure out where the bottleneck is, and we're beginning to think we may need to move to a server with more horsepower (even though the current one only sits at around 40% CPU utilization, on average). And yes, all best practices are in place for NUMA spanning, OS optimization, and BIOS settings on the B200 M4s.
Side note - we are on core-based licensing, right now the server is running as a 14 CPU VMware Windows 2016 VM and with 384GB of RAM, and SQL Server 2016 Enterprise Edition. The VM is given full resource allocation and CPU ready times remain at less than 5%. The Pure storage array does not seem to be hit very hard, it barely breaks a sweat most of the time.
With that said, I was wondering what you guys would consider a kick ass SQL host in the $10k-15k dollar range. Ideally, two CPUs running at 3.5 GHz or above, whatever RAM, but I am open to opinions. I built one out at Puget systems with two Xeon 6226R's, 384GB of RAM, and some NVME SSD's. Then I would either possibly add a PCIe NVME card with a couple of drives running in RAID 0, or I could attach a FCoE LUN off of the Pure array for DB and log storage.
Any input is appreciated!