Home Forums SQL Server 2008 SQL Server 2008 Administration Number of files for database MDF RE: Number of files for database MDF

  • October 9, 2013 at 12:59 pm

    #1657289

    GilaMonster (10/9/2013)

    First question, why are you splitting it, recoverability or performance? If performance, have you checked whether the current bottleneck is IO?

    Yes, the average stalls per write on tempdb is 60ms and read isn't much better...

    The big SELECT .. FROM (SELECT ... FROM .. UNION ALL SELECT ... FROM ...) t ORDER BY ... probably uses loads of tempdb... Probably would get better results by putting tempdb on it's own LUN, probably SSD disk... (I mixed up two servers I'm checking :(... this one has tempdb on a RAID5 15K disks along with the data files...)

    Thanks,

    Pedro


    If you need to work better, try working less...