SQL Server Performance

Clean Install..

Discussion in 'Performance Tuning for Hardware Configurations' started by droesch99, Aug 11, 2003.

  1. droesch99 New Member

    Hi, we are adding disk and freshly installing SQL/OS and converting to RAID 10. My question is, I would like to utilize the exisiting disk because that is now going to be on its own SCSI channel.

    What would be best:
    1) Put the transaction logs on the existing drive, that is alread in place, and put the DB on the newly created volume..? (Breaking them apart and onto seperate channels.)

    2) put master/tempdb onto the existing volume, to break it off from the main channel, and get some traffic off of it..

    3) or do something different...????



    -David Roesch
    San Diego, Ca
  2. satya Moderator

  3. ykchakri New Member

    I would go with your first option, putting Tlogs on the existing drive. As Tlogs acess the disk sequentially, it is better to dedicate the disk for Tlogs, which gives better performance with Updates, inserts Or anything that acceses Tlogs.

  4. droesch99 New Member

    Thank you for all that info.. I will go that route.. <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />-David Roesch<br />San Diego, Ca

Share This Page