The CHECKPOINT duration argument sets a target time in seconds. This post times a manual checkpoint on a database with 130 MB of dirty pages, and shows that a long duration slows it badly while a short one does not make it faster. It also shows that a backup flushes dirty pages by itself.
SQL SERVER – Impact of CHECKPOINT and DBCC DROPCLEANBUFFERS on Memory
Today we will discuss the Impact of CHECKPOINT and DBCC DROPCLEANBUFFERS on Memory. We will see how each of them clears dirty and clean pages from the buffer memory pool.
How Dirty or Clean is SQL SERVER’s Memory? – Interview Question of the Week #229
Question: How Dirty or Clean SQL SERVER Database is (by Memory)?
This blog post is the follow up of the earlier blog post on the same subject.
Personal Technology – Bluetooth Volume Problem with Windows Volume Control
Bluetooth volume stays the same from 1 to 100 in Windows? Diagnose Absolute Volume, use a reversible fix, and restore the original setting.
Dirty Pages and Clean Pages in the SQL Server Buffer Pool
Dirty pages are pages in memory that SQL Server has changed but not yet written to the data file. This post counts dirty pages and clean pages per database and per object, then watches a CHECKPOINT bring the dirty count to zero. It also explains why you should not try to clean the buffer pool on a production server.
Foreign Key Checks in Insert Plans: The Cost of Each Constraint
Before you drop a foreign key to speed up a load, look at what it costs. This walk-through shows the Assert, the two parent lookups, and the trust trap.
SQL SERVER – Natively Compiled Stored Procedures and Location of Compiler
I recently implemented a Memory Optimized Table solution at one of the large financial organizations while working on Natively Compiled Stored Procedures.