checkpoint is a database event. when checkpoint happens, all dirty blocks(pages) in the memory are written to database data files.
1
vote
1answer
138 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 ...
4
votes
1answer
1k 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
161 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
283 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 ...
