DB in Simple recovery mode + disk setup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DB in Simple recovery mode + disk setup

If you have 4 disks available (on a controller with 2 channels) and you know you will host databases that are in Simple Recovey mode only on the server (with a lot of reads and writes, 60% read 40% write) would you: 1. Still seperate Data and Log on different channels as 2 x RAID1 2. Or would you set it up as 1 x RAID0+1 Currently this system is running on on single RAID1 and with a writelog waitstats percent of 73% causing a lot of CPU spikes. /Argyle
I would go with option 1 which is an advantage on option 2.
This reduces the CPU strikes and less disk queue length. _________
Satya SKJ

If you presume in future don’t have a space problem, I would go with option 1 too. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell