 Dbcc Dropcleanbuffers
DBCC DROPCLEANBUFFERS
Remove all clean buffers from the buffer pool.
Syntax
DBCC DROPCLEANBUFFERS [WITH NO_INFOMSGS]
Key:
WITH NO_INFOMSGS - Suppress all information messages.
This command is useful to test queries with a cold buffer cache without shutting down and restarting the server.
To produce a 'cold' buffer cache with all dirty pages written to disk, first use CHECKPOIN |