A few months ago, during my WSUS adventures with the database and IIS pool problems, I spotted an additional issue. The WSUS database with its transaction log is installed on drive C.
C drive is a system drive and it shouldn’t be used for any storage of data. Even more, you can achieve up to 30% better operations with the MS SQL server when the database and its log are on separate physical drives or virtual disks. Continue reading