Post reply

LOGBUFFER lastwaitype

  • December 20, 2005 at 12:16 pm

    #113050

    Hello!

        I have noticed LOGBUFFER in lastwaitype column in sysprocesses table. I

    couldn't find a description for this value. Does anyone have a clue what

    this waittype means. Could this be an indication of certain bottleneck?

    Thanks,

    Igor

  • December 20, 2005 at 3:51 pm

    #610742

    From MSDN T-SQL: Logbuffer waittype -- 'Occurs when a task is waiting for space in the log buffer to store a log record. Consistently high values may indicate that the log devices cannot keep up with the amount of log being generated by the server.'

    Do you have your transaction logs running on their own physical drives?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • December 20, 2005 at 3:55 pm

    #610743

    I do not. I noticed that this waittype appears quite often. This makes me think of moving log to the separate drive.

     

    Thanks,

    Igor

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

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