My company is looking to purchase a new SQL server and we are looking into hardware for it. We are looking at an HPE DL325 Gen11 with 64 to 128 GB for system memory. A 9004 Epyc either 8 or 16 core. We want to use a 2x 480GB for the boot drive and U.2 for the SQL databases.
What are some recommendations for the storage, we want to use U.2 ssds for the speed and so we don’t add anymore hard drives to the environment.
We also intend to install fresh Windows Server 2022 and SQL Server 2022.
What licensing are you on for SQL? Our company is now on the new licensing model and no matter what you gotta pay for 16 cores, so if you get 8, you are then paying for 8 more you don’t even have.
Being HP they will probably limit you to their SSD oems but kioxia or solidigm are good choices for DB workloads.
Sql will absolutely fly on Genoa/9004 epyc CPUs, your dbas will be blown away.
Id probably do a 4 drive setup so you could do a stripe or a mirror of 4x4tb or 4x8tb. Even if you don’t use the space that just means more total write endurance over the lifetime of the box.