SQL Server Performance

DB in Simple recovery mode + disk setup

Discussion in 'Performance Tuning for Hardware Configurations' started by Argyle, Nov 7, 2003.

  1. Argyle New Member

    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.

  2. satya Moderator

    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
  3. Luis Martin Moderator

    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

Share This Page