CHECKPOINT generates timeout

· Uncategorized

On my SQL2008R2 (RTM) instance I get following timeout error after 5 minutes when running a manual CHECKPOINT in TEMPDB:

Msg 845, Level 17, State 1, Line 2
Time-out occurred while waiting for buffer latch type 3 for page (1:763), database ID 2.

After inspecting waittimes, it appeared it was waiting for a PAGELATCH_UP on page 2:1:203. But subsequent tests gave me other pages as being blocked.

FYI: this is a SQL2008R2 server that has databases with read_committed_snapshot and allow_snapshot_isolation ON. It turns out that this only occurs when there are records in the version store. If version store is empty, checkpoint runs subsecond.

On SQL2012 this is not an issue either. I’ll try again after having installed the latest SP for SL2008R2.

To be contunued

1 Comment

Comments RSS
  1. geertdcod

    I installed SP2 on SQL2008R2 and the issue is solved

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: