Post reply

Error for tempDB log file full

  • May 5, 2005 at 3:41 pm

    #86528

    I am getting this error on simple select query. It stared with tempDB log file full and I made changes for growth of tempdb to 10% and truncated log file. I start getting this error.

    Msg 845, Sev 17: Time-out occurred while waiting for buffer latch type 3 for page

    I am running SQLServer 2000 and sp3a. Does anybody know any reasons.

     

  • May 6, 2005 at 6:16 am

    #557320

    You should obviously increase the initial size of tempdb; one doesn't want autogrowth ocurring for any database, of course.  You cannot truncate tempdb's log file because tempdb uses the simple recovery model.

    From my experience, most 845 errors occur after someone monkeyed around with the server's configuration settings.  If, however, your applications make heavy use of tempdb (e.g. Siebel), you may need to optimize the tempdb database: http://support.microsoft.com/?id=328551.



    --Jonathan

Viewing 2 posts - 1 through 1 (of 1 total)

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