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…