New server setup for SQL DB

[danrcf]

Hi,

Need some help in putting a Server to run a company program it contains about 3 sql db, with quite a bit of information, and is used everyday by 10 users.
It will be just to run this, but i need to put something quite rebust and with reduncy in case of ssd failure.

My idead is
Xeon cpu
64gb ram
1TB RAID 1+0

Any ideas or recommendations will be much appreciated, thanks

 

[YeOldeStonecat]

Any idea of how large the databases are?
Building a server for SQL Express that can only handle small database sizes, and building a server for full blown SQL....two very different approaches. Esp if the databases are very large.

I like RAID 10 for full SQL servers...(well, any/all on prem servers for the past quite a few years). R10 on SSD. Spindle SAS drives (like 15,000rpm or 10,000 rpm)...these days, too old 'n slow for servers. Nearline SAS...7,200 rpm...aka desktop spindles...nope...just...nope.

How many cores in the CPU also important....depending on database sizes.

Their existing environment where the domain controller is...not already a Hyper-V host to install this on as a guest?