DBCC DROPCLEANBUFFERS in Microsoft Sql Server

Empty the buffer pool in SQL Server

Removes all clean buffers from the buffer pool.

Syntax
DBCC DROPCLEANBUFFERS

Remarks
Use DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server.

Leave a Reply