checkpoint is a database event. when checkpoint happens, all dirty blocks(pages) in the memory are written to database data files.

learn more… | top users | synonyms

0
votes
1answer
34 views

How can I solve postgresql problem after deleting wal files?

I turned the archive_mode on on my postgresql configuration for testing a backup server . And since the wal files took lots of disk space, after my test I turned it off and also deleted the wal files. ...
1
vote
2answers
305 views

Are logs in the LDF file being removed after a checkpoint?

Using the fn_dblog I can get the active portion of the online transaction log of my database. But after every checkpoint I can only see 2 entries showing the beginning of the checkpoint ...
1
vote
0answers
133 views

What is an incremental checkpoint (in the context of indirect checkpoints)?

I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this: And the details of the selected event are: The ...
1
vote
1answer
587 views

Sql Server rollback to some point in time

This seems like a fairly common scenario, yet I'm not sure how to do this. I have a very large database (think a lot of terabytes), which makes it impossible to create a full backup. At some point, I ...
6
votes
2answers
4k views

MS SQL Server - Checkpoint process stuck in SLEEP_BPOOL_FLUSH

We seem to have a problem that came out of nowhere. The checkpoint process is stuck in SLEEP_BPOOL_FLUSH state, and not actually reducing the usage in the log file. This never seemed to happen ...
3
votes
1answer
489 views

What happens when checkpoint_segments reached?

I'm a bit confused with checkpoint_segments definition in PostgreSQL documentation. What happens when checkpoint_segments reached? The dirty pages in shared_buffers written to WAL. Then what is the ...
3
votes
3answers
645 views

What does “thread” mean in “thread checkpoints” context?

The following excerpt is from Oracle concepts. Maybe this is a stupid question, but I really need your help to understand it. My question is: What's does the thread mean in the context thread ...