View the interinternal Data Page's small plug-in internals Viewer (continued)

View the interinternal Data Page's small plug-in internals Viewer (continued)

I continued to use internals viewer to view several system databases and the adventureworks database with a large data volume tonight, because I used

This database has done some experiments.

There will be no more texts to read.

Master

Model

MSDB

Tempdb

Fragment

 

Dirty page

 

As we all know, adds, deletes, and modifies data first in the memory, which can greatly speed up data operations. When the data in the memory is modified, when the data on the disk has not been modified,

The so-called "Dirty pages" are generated. Dirty pages contain dirty pages of uncommitted transactions and committed transactions.

The following three methods are generated to synchronize memory and disk data:

1. lazywrite (inert writer)

2. Checkpoint

3. eagerwrite (diligent writer)

 

Continue to work overtime. Recently, I am really tired ~~