Time-out occurred while waiting for buffer latch type 2
Yesterday 2 jobs that run against same database failed with this error in job history.
“OnError,ServerName,AliasLogon,PackageRuned,{8AC850EB-587C-4ACC-A4C5-3CB687B1286E},{D66F0567-10CF-41BD-B356-8FB17FD85AB2},2/11/2008 2:46:20 PM,2/11/2008 2:46:20 PM,0,0x,Time-out occurred while waiting for buffer latch type 2 for page (1:16770184), database ID 31.”
Solution:
Both of this jobs were pulling data from remote server. On Remote server Bunch of processes were getting blocked becuase of the Netbackup (Vertias) that couldn’t finish and this started a sequence of failing and blocking process on that server.
据上面的理解，我觉得是因为其他进程在抢资源，导致job堵塞。
