none
Relocate tempdb files?

    Question

  • newbie: 

    I'm setting up SQL 2008 on a pair of mirrored drives (Raid 1+0).  Is there any performance advantage to creating a logical volume and setting up the tempdb files on that volume?

    I've read that putting the temp files on their own array increases performance.

    Monday, April 01, 2013 4:07 AM

Answers

  • Hello,

    RAID 10 will provide great performance on high IOPS requirements. I don’t see any benefit on creating a separate logical volume, if physically they are the same.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by j.w.a Monday, April 01, 2013 6:15 PM
    Monday, April 01, 2013 4:22 AM
    Moderator

All replies

  • Hello,

    RAID 10 will provide great performance on high IOPS requirements. I don’t see any benefit on creating a separate logical volume, if physically they are the same.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by j.w.a Monday, April 01, 2013 6:15 PM
    Monday, April 01, 2013 4:22 AM
    Moderator
  • Hi - thanks for schooling me.
    Monday, April 01, 2013 6:16 PM