The more research I do, the more confused I get, so I'm hoping for some guidance and recommendations. I'm building a new server for my work that needs to run the database for our point of sale system. The software installs and configures everything on the system drive, and I'm not sure if I change that if it will mess up the program or not, so currently I'm looking to install and run everything one one logical drive. We're also a small company with 15 employees and probably around 1,000 transactions or database requests per day, with a good balance between reads and writes. Nothing too crazy going on here but I feel like the dual core processor, 4gb of ram, and single 10,000 rpm drive are not cutting it anymore. I also only require around 60gb of hard drive space right now, but would like to have plenty to spare.
From what I can tell, I should do a RAID 1, or a RAID 10 if I can afford the extra disks. Should I do SCSI, SAS, or SATA? Would I even notice the difference between them? I'm not even sure which one's the "best". Any other RAID configurations I should be aware of or look into? Is PCI Express 2.0 the best interface to buy for a RAID controller card? What about SSD, would that be a good option in my situation?
Thanks for the help with all my random questions!