Transact-SQL Reference
DBCC DROPCLEANBUFFERS
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.
Result Sets
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Permissions
DBCC DROPCLEANBUFFERS permissions default to members of the sysadmin fixed server role only, and are not transferable.