Dirty buffer pages after issuing CHECKPOINT
5
votes
1
answer
1058
views
I am currently working on a test system and due to the nature of the queries I want to optimise, I am trying to simulate a "cold" read a well as I can. Part of that is clearing the buffer cache before performing the queries. From everything I can find dirty buffer pages are supposed to be written during a checkpoint. However, even after issuing a CHECKPOINT, there still seem to be 169 dirty pages of my database in the buffer pool (assessed via
SELECT * FROM sys.dm_os_buffer_descriptors WHERE database_id=7 AND is_modified=1
).
Is there anything I am misunderstanding about checkpoints or the content of sys.dm_os_buffer_descriptors? If not, why do I still have dirty pages after they were supposedly written away?
Asked by Florian
(341 rep)
Dec 3, 2020, 10:55 AM
Last activity: Dec 4, 2020, 08:28 PM
Last activity: Dec 4, 2020, 08:28 PM