none
WriteLog wait type RRS feed

  • Question

  • runtime                        waiting_tasks_count  wait_time_ms         max_wait_time_ms     signal_wait_time_ms  wait_type                                                  
    ------------------------------ -------------------- -------------------- -------------------- -------------------- ------------------------------------------------------------                                                
    2019-06-06T14:49:13.390                     1159087              8439614                 9456                51289 WRITELOG                  
    2019-06-06T15:26:47.187                     1915753             13861957                 9456                98141 WRITELOG 

    I have got the above figures of the wait stats. Seems like it's not so realistic, becauase

    I only around half an hour , it has  5,422,343 ms ( 13861957 - 8439614 )    which means 5422 s !!!!!!!!!!!!!!!

    seems weird

    and also the max_wait_time_ms is 9s.

    Monday, September 23, 2019 3:35 AM

All replies

  • Remember, 10 or 100 or 1000 SPIDs can all be waiting at the same time, they all count up waits.

    Josh


    Monday, September 23, 2019 5:38 AM
  • yes. that's what exactly I am thinking . thanks
    Monday, September 23, 2019 6:11 AM
  • Hi sakurai_db,

     

    I am glad to know that your problem has been solved In order to close this thread, please  mark useful replies as answers. By doing so, it will benefit all community members who are having this similar issue.  Your contribution is highly appreciated.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, September 24, 2019 1:15 AM