I just learned from an answer to this question that the
.ldf files that SQL Server uses are an important pair for the database. I previously thought the .ldf was just a non-critical log for backups or audits.
Anyway, our server right now has the
.mdf on a SSD and the
.ldf on the main HDD with Windows. I set it up like that because I assumed the
.mdf was the most performance critical file location.
But now it seems like the
.ldf is actually the first place data is written in the event of an
UPDATE, and then the
.mdf is written to later on.
Should I put both files on the SSD? Or is it better if they're on different drives, even if one of them is an HDD? (and if so, which file should go where?)
If it makes a difference,
SELECT performance is more important to me (and more common) than