Post reply

TempDB and SQL Error 845

  • June 1, 2009 at 2:30 pm

    #1003030

    TRACEY (6/1/2009)

    Is this total or per DRIVE DISKS...to select.

    Individually for each drive that has SQL data or log.

    Taking the total's not very useful as more idle drives can skew the results.

    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

  • June 1, 2009 at 7:24 pm

    #1003116

    Thanks Gila...

  • July 9, 2009 at 9:33 am

    #1022495

    Just wanted to give an update: All our server team did to resolve this problem was move the SAN to a new "cabinet" and the problem went away. Apparently hardware WAS causing the error.

    Having said that, let me point out that performance of the datbase and jobs is still poor, but mainly due to inefficient design and possibly db configuration/layout. Either way, the Error 845 issue was resolved.

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply