• jrestuccio (4/12/2013)


    [C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf] in database [tempdb] (2).

    I suspect that's a good part of the problem. If I had to guess, lots of TempDB usage and TempDB still at default config on a not-so-fast drive.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass