Export (0) Print
Expand All

DBCC DROPCLEANBUFFERS

SQL Server 2000

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft