MSDE, transaction logs and partitions
Posted on 2010-11-15
We have an application that runs on Windows 2008 servers. It requires a DB so we'll also have MSDE installed on the same box.
I understand that it's generally better to have transaction logs on RAID 1 and the database on RAID 5.
We could have the transaction logs on the same RAID group as the C drive in that case.
C: OS and transaction logs
D: Application and MSDE database
However, is there any issue with having two write intensive 'applications' (the OS and the transaction logs) on the same partition?
Also, I guess there is a higher risk placing them on the C drive in case the logs fill up the C drive and knock the server over?
What are people's recommendations?