Chapter 1: The Statement Cache

Purging the statement cache

Run dbcc purgesqlcache to remove all the SQL statements from the statement cache. Any statements that are currently running are not removed.

See “Changes to dbcc” for syntax information.

You must have the sa_role to run dbcc purgesqlcache

dbcc purgesqlcache prints the following message:

dbcc purgesqlcache

DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.