I have a server with 1 SATA drive in it. I was told to get better performance, I should add a 2nd drive (non-RAID) to divide SQL files.(logs on one and db on the other)
The idea is that SQL can then do simultaneous reads and writes.
Is that true with SATA drives? I know it's recommended with SCSI drives but I'm not 100% sure that SATA will actually do true simultaneous access.