Archives for March, 2013

CHECKPOINT generates timeout


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 […]

What happens if the Version Stored gets filled completely


What happens if your version store in TEMPDB fills up? Opposite to transactionlog behavior (Where the process that fills the tranlog is rolled back), the versionstore doesn’t penalize the process responsible for generating the versions, but rather the poor select statement that needs to read from the version store. How unfair… The script hereunder demonstrates […]