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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Error 41368: Memory-Optimized Tables and Transactions
Error 41368 appears when an explicit transaction reads a memory-optimized table at the read committed level. This post reproduces the error, fixes it with a table hint or a database option, and shows the two related errors that the fixes do not cure. It also answers what the option changes for other tables.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.