Latch Timeout: To worry or not to?   1 comment

Hey, I seldom see these messages in ERROLROG, is this something I should be concerned about?

[WARNING] 2013-02-14 05:25:15.97 spid61      Timeout occurred while waiting for latch: class ‘DATABASE_CHECKPOINT’, id 0000000017560830, type 4, Task 0x000000000043EBC8 : 0, waittime 300, flags 0x1a, owning task 0x00000000009F0508. Continuing to wait.

The short answer is – No. This ‘particular’ message is not to be concerned about for the period it occurred on this server.

Why do I say that? Want to know more. Then go ahead and read the longer version.

Read the rest of this entry »