Empty the buffer pool in SQL Server
Removes all clean buffers from the buffer pool.
SyntaxDBCC DROPCLEANBUFFERS
Remarks
Use DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server.
Removes all clean buffers from the buffer pool.
SyntaxDBCC DROPCLEANBUFFERS
Remarks
Use DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server.