• Checking both logs reveals a tcp error. Are the the latch waits a result of the tcp error? Also noticed a significant increase in round trip times during this period.

    Date1/13/2016 9:36:59 AM

    LogSQL Server Agent (Archive #1 - 1/13/2016 9:47:00 AM)

    Message

    [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]

    ---------------------------------------------------------------------------------------------------

    Date1/13/2016 9:39:55 AM

    LogSQL Server (Archive #2 - 1/13/2016 9:48:00 AM)

    Sourcespid1415

    Message

    A time-out occurred while waiting for buffer latch -- type 2, bp 0000005454FB3A40, page 9:7573137, stat 0xc0000b, database id: 5, allocation unit Id: 72057597204037632, task 0x00000000043DEBC8 : 0, waittime 300, flags 0x1a, owning task 0x00000000273C4E08. Not continuing to wait.