Home Forums SQL Server 2008 SQL Server 2008 Administration tempdb files on SSD RE: tempdb files on SSD

  • January 23, 2013 at 12:52 pm

    #1580241

    Steve Jones - SSC Editor (1/22/2013)

    Tara-1044200 (1/22/2013)

    but i am planning to put them on a single SSD drive which i asusme would be 8 files each of 100gb. so i think any file would be used out of 8 during a transaction untill it reaches 800gb right?

    A single drive is a bad idea just in case of failure. At the very least, spread out across 2.

    +1

    I have had very good results by putting tempdb data + log on a single raidgroup of local SSD's, both RAID1 pairs and RAID5 sets. One drive failure, and it still works. SSD's do, indeed, fail from time to time.