sa_flush_cache system procedure

Function

Empties all pages in the database server cache.

Syntax

sa_flush_cache ( )

Permissions

DBA authority required.

Description

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.