Empties all pages in the database server cache.
sa_flush_cache
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Database administrators can use this procedure to empty the contents of the database server cache. This procedure affects the catalog store. It is of use in performance measurement to ensure repeatable results.