Recommended Setup
- by Chris Ryan
I have been running into issue with my MSSQL Database setup with speed. Here is my scenario.
About 100M Rows
Average: 1k Updates Per Second
Hard Drives: RAID 10 SSD MDF
--Active Time: 0
Log Drives: 1 SSD LDF - Simple Recovery
--Active Time 99.9
--Queue: 8
I do not need a back up of the log so it is set to simple recovery but my bottleneck is still at my log. I get high WAITLOG times and thus it can not update any faster. I can't do bulk updates/transactions and each update needs to be one at a time.
Is my only option to increase write performance of the log drives, add a RAID drives? Any suggestions on increasing the performance?