Memory issue?

  • SqlScared

    Ten Centuries

    Points: 1000

    Last night the server team installed an additional 512GB(1TB total) of memory on the passive node of my cluster. I failed over and reconfigured max memory as per best practice

    and all looked well until this morning when Sql server became unresponsive for about 6 minutes. I failed back to the previous node and everything went back to normal. Checked the error logs and saw multiple buffer latch errors. Trying to determine root cause, any help would be appreciated.

    SQL 2008R2 SP3

    Windows Server 2008 R2 SP1 64bit

    Logical CPU Count - 80 Hyperthread Ratio - 20 Physical CPU Count – 4

    Not using LPIM

    DUMP:

    ch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7D681E3A8, type 4, Task 0x000000C7E88E1708 : 12, waittime 600, flags 0x1a, owning task 0x000000311ECE9048. Continuing to wait.

    2016-01-13 09:45:00.85 spid8254 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7CAE2D458, type 4, Task 0x000000C7FDCDD708 : 11, waittime 600, flags 0x1a, owning task 0x0000002595079DC8. Continuing to wait.

    2016-01-13 09:45:00.85 spid7030 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7D681E3A8, type 4, Task 0x0000000026DCEBC8 : 13, waittime 600, flags 0x1a, owning task 0x000000311ECE9048. Continuing to wait.

    2016-01-13 09:45:00.87 spid8254 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7CAE2D458, type 4, Task 0x0000000005718988 : 12, waittime 600, flags 0x1a, owning task 0x0000002595079DC8. Continuing to wait.

    2016-01-13 09:45:00.88 spid8254 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7CAE2D458, type 4, Task 0x000000065F94F708 : 13, waittime 600, flags 0x1a, owning task 0x0000002595079DC8. Continuing to wait.

    2016-01-13 09:45:01.08 spid2962 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000065F94EE08 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:01.18 spid9597 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x00000099B7F50988 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:01.19 spid18544 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C476929048 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:01.27 Logon Error: 18456, Severity: 14, State: 46.

    2016-01-13 09:45:01.27 Logon Login failed for user 'sa'. Reason: Failed to open the database configured in the login object while revalidating the login on the connection. [CLIENT: 172.16.9.169]

    2016-01-13 09:45:01.28 spid13797 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000000432A748 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:01.39 spid9605 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x00000034C88B3948 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:01.43 spid6637 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C80E289458, type 4, Task 0x000000C7E88E1B88 : 12, waittime 600, flags 0x1a, owning task 0x000000C7F0232988. Continuing to wait.

    2016-01-13 09:45:01.44 spid6637 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C80E289458, type 4, Task 0x00000007086BC088 : 11, waittime 600, flags 0x1a, owning task 0x000000C7F0232988. Continuing to wait.

    2016-01-13 09:45:01.46 spid6637 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C80E289458, type 4, Task 0x000000B837DF3948 : 13, waittime 600, flags 0x1a, owning task 0x000000C7F0232988. Continuing to wait.

    2016-01-13 09:45:01.46 spid8254 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7CAE2D458, type 4, Task 0x000000C7F0232508 : 15, waittime 600, flags 0x1a, owning task 0x0000002595079DC8. Continuing to wait.

    2016-01-13 09:45:01.55 spid2498 A time-out occurred while waiting for buffer latch -- type 2, bp 0000003FBCFDBE80, page 8:134, stat 0xc0000b, database id: 2, allocation unit Id: 1125899909070848, task 0x0000000027094988 : 0, waittime 300, flags 0x3a, owning task 0x000000C7B7F2D948. Not continuing to wait.

    2016-01-13 09:45:01.57 spid9556 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000CD0A2E62C8 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:01.71 spid15250 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C803485458, type 4, Task 0x000000C7AF6842C8 : 12, waittime 600, flags 0x1a, owning task 0x00000009F5F4A088. Continuing to wait.

    2016-01-13 09:45:01.71 spid5422 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000000874A6BDC8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:01.71 spid15250 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C803485458, type 4, Task 0x000000C5BB659288 : 11, waittime 600, flags 0x1a, owning task 0x00000009F5F4A088. Continuing to wait.

    2016-01-13 09:45:01.72 spid15250 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C803485458, type 4, Task 0x0000000026DC5288 : 13, waittime 600, flags 0x1a, owning task 0x00000009F5F4A088. Continuing to wait.

    2016-01-13 09:45:01.72 spid15250 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C803485458, type 4, Task 0x000000C6F6ECD708 : 15, waittime 600, flags 0x1a, owning task 0x00000009F5F4A088. Continuing to wait.

    2016-01-13 09:45:01.83 spid1753 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7E8F63458, type 4, Task 0x00000020F680FB88 : 15, waittime 600, flags 0x1a, owning task 0x00000010402502C8. Continuing to wait.

    2016-01-13 09:45:01.85 spid2559 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000CA21212508 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:01.86 spid14839 Error: 18056, Severity: 20, State: 46.

    2016-01-13 09:45:01.86 spid14839 The client was unable to reuse a session with SPID 14839, which had been reset for connection pooling. The failure ID is 46. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.

    2016-01-13 09:45:01.96 spid4189 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x0000000026D29048 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:01.99 spid6637 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C80E289458, type 4, Task 0x000000B368107708 : 15, waittime 600, flags 0x1a, owning task 0x000000C7F0232988. Continuing to wait.

    2016-01-13 09:45:02.07 spid3616 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7ABBD4738, type 4, Task 0x0000000882398988 : 14, waittime 600, flags 0x1a, owning task 0x00000008D6998748. Continuing to wait.

    2016-01-13 09:45:02.21 spid8724 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C982414E08 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:02.22 spid106 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C4B55E9DC8 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:02.27 spid3616 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7ABBD4738, type 4, Task 0x00000024F306DDC8 : 13, waittime 600, flags 0x1a, owning task 0x00000008D6998748. Continuing to wait.

    2016-01-13 09:45:02.33 spid3704 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7E5E1D458, type 4, Task 0x000000C4B0284508 : 11, waittime 600, flags 0x1a, owning task 0x000000C7B7F2C748. Continuing to wait.

    2016-01-13 09:45:02.33 spid3704 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7E5E1D458, type 4, Task 0x000000117B9B6E08 : 13, waittime 600, flags 0x1a, owning task 0x000000C7B7F2C748. Continuing to wait.

    2016-01-13 09:45:02.34 spid3616 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7ABBD4738, type 4, Task 0x000000B2E5121048 : 15, waittime 600, flags 0x1a, owning task 0x00000008D6998748. Continuing to wait.

    2016-01-13 09:45:02.34 spid3704 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7E5E1D458, type 4, Task 0x000000BCE27CE748 : 12, waittime 600, flags 0x1a, owning task 0x000000C7B7F2C748. Continuing to wait.

    2016-01-13 09:45:02.48 spid15129 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7AB414738, type 4, Task 0x0000002100213708 : 11, waittime 600, flags 0x1a, owning task 0x000000311ECE9DC8. Continuing to wait.

    2016-01-13 09:45:02.69 spid15129 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7AB414738, type 4, Task 0x000000C72DCF2088 : 12, waittime 600, flags 0x1a, owning task 0x000000311ECE9DC8. Continuing to wait.

    2016-01-13 09:45:02.91 spid13384 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000CA9D5F7708 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:02.91 spid2453 A time-out occurred while waiting for buffer latch -- type 2, bp 0000003FBCFDBE80, page 8:134, stat 0xc0000b, database id: 2, allocation unit Id: 1125899909070848, task 0x000000C718D53708 : 0, waittime 300, flags 0x3a, owning task 0x000000C7B7F2D948. Not continuing to wait.

    2016-01-13 09:45:02.93 spid3366 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000B837DF3288 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:03.14 spid15129 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7AB414738, type 4, Task 0x00000025A3D59288 : 13, waittime 600, flags 0x1a, owning task 0x000000311ECE9DC8. Continuing to wait.

    2016-01-13 09:45:03.20 spid3616 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7ABBD4738, type 4, Task 0x000000B30ECA6748 : 11, waittime 600, flags 0x1a, owning task 0x00000008D6998748. Continuing to wait.

    2016-01-13 09:45:03.28 spid13327 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000132D001B88 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:03.37 spid3704 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7E5E1D458, type 4, Task 0x000000B66C43DDC8 : 15, waittime 600, flags 0x1a, owning task 0x000000C7B7F2C748. Continuing to wait.

    2016-01-13 09:45:03.49 spid15129 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000C7AB414738, type 4, Task 0x0000000692576748 : 15, waittime 600, flags 0x1a, owning task 0x000000311ECE9DC8. Continuing to wait.

    2016-01-13 09:45:04.01 spid5954 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000000026D76988 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:04.63 spid7102 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000000027046508 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:04.83 spid1814 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C839A01B88 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:05.30 spid3630 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000845F64B708 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:05.37 spid863 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C8B47CD048 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:05.69 spid8240 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000000527CE08 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:05.77 spid3760 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C98F2CB948 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:05.79 spid5107 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x00000020F680E2C8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:06.18 spid16216 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000000026DCEE08 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:06.35 spid15078 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000D090189458, type 4, Task 0x000000CA00106988 : 13, waittime 300, flags 0x1a, owning task 0x000000C87F3B1B88. Continuing to wait.

    2016-01-13 09:45:06.36 spid8975 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000B704613B88 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:07.22 spid1665 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000003211D76088 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:07.34 spid285 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x00000000266B7DC8 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:07.55 spid871 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x00000096DB015948 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:07.73 spid813 A time-out occurred while waiting for buffer latch -- type 2, bp 0000003FBCFDBE80, page 8:134, stat 0xc0000b, database id: 2, allocation unit Id: 1125899909070848, task 0x000000C790C18508 : 0, waittime 300, flags 0x3a, owning task 0x000000C7B7F2D948. Not continuing to wait.

    2016-01-13 09:45:07.97 spid2931 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C5B6FF3D00, page 9:7572951, stat 0xc0000b, database id: 5, allocation unit Id: 72057597238575104, task 0x000000C8E6D95DC8 : 0, waittime 300, flags 0x3a, owning task 0x00000000273C5708. Not continuing to wait.

    2016-01-13 09:45:08.67 spid11484 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000A6EB5E2508 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:09.13 spid4905 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000CA6C673048 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:10.67 spid18232 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000CD0A2E7948 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:11.41 spid1170 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000CE16E54088 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:11.50 spid4496 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000A288229B88 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:11.81 spid15015 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000000476D4C8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:12.42 spid3639 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C56F0A2088 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:12.99 spid5669 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000CA2199F4C8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:13.64 spid9514 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C795DA6508 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:13.79 spid1853 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x0000000C69AF3048 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:14.56 spid16705 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C9720AC988 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:15.74 spid6555 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C80DCE14C8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:16.10 spid16302 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000000026752988 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:16.25 spid6208 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000A1BFA5B80, page 9:4966369, stat 0xc00009, database id: 5, allocation unit Id: 72057597252403200, task 0x000000C7AF1FF288 : 0, waittime 300, flags 0x1a, owning task 0x000000C9720AD288. Not continuing to wait.

    2016-01-13 09:45:18.23 spid4138 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000547A9F7288 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:18.43 spid9626 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C831306748 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:18.68 spid9899 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000CAB0B6EBC8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:18.74 spid3163 A time-out occurred while waiting for buffer latch -- type 2, bp 0000003FBCFDBE80, page 8:134, stat 0xc0000b, database id: 2, allocation unit Id: 1125899909070848, task 0x000000C715D64988 : 0, waittime 300, flags 0x3a, owning task 0x000000C7B7F2D948. Not continuing to wait.

    2016-01-13 09:45:18.79 spid14300 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000000004FE1DC8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:18.96 spid17314 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C7D1C77708 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:18.97 spid3907 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C83214DDC8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:19.23 spid3137 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C5B6FF3D00, page 9:7572951, stat 0xc0000b, database id: 5, allocation unit Id: 72057597238575104, task 0x000000CA00106E08 : 0, waittime 300, flags 0x3a, owning task 0x00000000273C5708. Not continuing to wait.

    2016-01-13 09:45:19.29 spid6649 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000002669DDC8 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:19.46 spid1294 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000003FA1750088 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:19.52 spid4974 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000000027047288 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:20.42 spid17001 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000BB1BC25948 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:20.63 spid5449 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000000004752748 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:21.08 spid931 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000BA9CB15708 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:22.44 spid4037 Timeout occurred while waiting for latch: class 'APPEND_ONLY_STORAGE_INSERT_POINT', id 000000C156A67CD8, type 4, Task 0x000000C9720AC2C8 : 0, waittime 300, flags 0x1a, owning task 0x000000C9720AD288. Continuing to wait.

    2016-01-13 09:45:22.49 spid15730 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x0000002103877948 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:22.59 spid18012 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x00000000043D54C8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:24.08 spid16044 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C87F4202C8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:24.53 spid5924 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C7BD579B88 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:24.57 spid13959 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000ADFA2C1948 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:25.78 spid13276 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000CA51BDE088 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:26.04 spid12487 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000CA6CB7C988 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:26.40 spid9888 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000CB0255A748 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:27.49 spid10637 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000561EAAC748 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:28.01 spid12424 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x00000000267BABC8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:29.11 spid7502 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x00000006B7B14508 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:29.29 spid11872 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C98F2CBB88 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:29.68 spid6646 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000C56067B708 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:32.12 spid4978 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x000000C8EB6262C8 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:32.17 spid11684 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x0000000004FE1288 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:33.19 spid8907 A time-out occurred while waiting for buffer latch -- type 2, bp 000000C36FFE7700, page 10:6717615, stat 0xc0000b, database id: 5, allocation unit Id: 373663164334080/92188187623424, task 0x000000BB1BC24BC8 : 0, waittime 300, flags 0x3a, owning task 0x0000000790BB0508. Not continuing to wait.

    2016-01-13 09:45:33.48 spid10932 A time-out occurred while waiting for buffer latch -- type 2, bp 0000000359FA7E00, page 5:58, stat 0xc0000b, database id: 2, allocation unit Id: 562949955649536, task 0x0000000026DC4988 : 0, waittime 300, flags 0x3a, owning task 0x000000C7BE1E3948. Not continuing to wait.

    2016-01-13 09:45:33.87 spid5889 A time-out occurred while waiting for buffer latch -- type 2, bp 0000003FBCFDBE80, page 8:134, stat 0xc0000b, database id: 2, allocation unit Id: 1125899909070848, task 0x000000757D16D4C8 : 0, waittime 300, flags 0x3a, owning task 0x000000C7B7F2D948. Not continuing to wait.

    2016-01-13 09:47:03.11 spid18s Timeout waiting for external dump process 21552.

  • Andrew G

    SSChampion

    Points: 12687

    Sounds almost exactly like this issue solved by Denny Cherry

    http://itknowledgeexchange.techtarget.com/sql-server/tempdb-latch-timeouts-with-lots-of-ram/

    He has a link to a MS blog post on the issue.

    http://blogs.msdn.com/b/slavao/archive/2005/04/29/413425.aspx

  • SqlScared

    Ten Centuries

    Points: 1000

    Thanks for the post.

  • SqlScared

    Ten Centuries

    Points: 1000

    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.

    Date 1/13/2016 9:36:59 AM

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

    Message

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

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

    Date 1/13/2016 9:39:55 AM

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

    Source spid1415

    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.

  • gdonufrio

    SSC Enthusiast

    Points: 100

    I had the same issue with Microsoft SQL Server 2017 (RTM-CU14) (KB4484710) - 14.0.3076.1 (X64)  on Windows Server 2016 Standard 10.0 <X64> (Build 14393: )

    But I can't realize how this problem continues to show even knowing that I have a newer and almost updated version of SQL Server

    Here are the errors:

    Message

    A time-out occurred while waiting for buffer latch -- type 3, bp 0000013412CB2E80, page 6:1293953, stat 0x10f, database id: 6, allocation unit Id: 72057598418223104, task 0x0000012E2C07ACA8 : 0, waittime 300 seconds, flags 0x1000000039, owning task 0x00000133BAAC24E8. Not continuing to wait.

    Failed:(-1073548784) Executing the query "BACKUP LOG [DB] TO DISK = N'\\\\xxx\\yyy\\DB..." failed with the following error: "Time-out occurred while waiting for buffer latch type 3 for page (6:1293953), database ID 6.

    BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    One or more recovery units belonging to database 'DB' failed to generate a checkpoint.

    This is typically caused by lack of system resources such as disk or memory,

    Examine previous entries in the error log for more detailed information on this failure.

    Msg 845, Level 17, State 1, Line 12

    Time-out occurred while waiting for buffer latch type 3 for page (6:65538), database ID 6.

    So:

    1. Why?
    2. This explanation is valid also for SQL Server 2017 CU14?
    3. The Disk, RAM, CPU was ok , the only thing is that I applied more RAM recently

    Can anyone please help me?

     

     

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

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