Hi Team, We have been observing frequent time-outs, an error as below and all the programs
SQL Version Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)
A time-out occurred while waiting for buffer latch -- type 3, bp 0000008AB9174D40, page 3:145584, stat 0x10f, database id: 2, allocation unit Id: 6488064, task 0x0000008AB0987468 : 0, waittime 300 seconds, flags 0x39, owning task 0x0000008AB004F848. Not continuing to wait.
the above error is preceded by a series of errors as below, while this is happens the SQL server go to unresponsive mode and I cant run queries or open job monitor, I could not even run SP_who2 or any query for that matter. It keeps on running with no results. Can you help on this as this is severely impacting business
Process 0:0:0 (0x253c) Worker 0x000000C0DF0E6160 appears to be non-yielding on Scheduler 6. Thread creation time: 13208569333534. Approx Thread CPU Used: kernel 31 ms, user 600078 ms. Process Utilization 30%%. System Idle 69%%. Interval: 611042 ms. Process 0:0:0 (0x253c) Worker 0x000000C0DF0E6160 appears to be non-yielding on Scheduler 6. Thread creation time: 13208569333534. Approx Thread CPU Used: kernel 31 ms, user 540453 ms. Process Utilization 30%%. System Idle 69%%. Interval: 550937 ms. Regards, Rago
