DBCC PROCCACHE (Transact-SQL)
Displays information in a table format about the procedure cache.
DBCC PROCCACHE [ WITH NO_INFOMSGS ]
To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
Allows for options to be specified.
Suppresses all informational messages that have severity levels 0 through 10.
The procedure cache is used to cache the compiled and executable plans to speed up the execution of batches. The entries in a procedure cache are at a batch level. The procedure cache includes the following entries:
- Compiled plans
- Execution plans
- Algebrizer tree
- Extended procedures
The following table describes the columns of the result set.
|num proc buffs||Total number of pages used by all entries in the procedure cache.|
|num proc buffs used||Total number of pages used by all entries that are currently being used.|
|num proc buffs active||For backward compatibility only. Total number of pages used by all entries that are currently being used.|
|proc cache size||Total number of entries in the procedure cache.|
|proc cache used||Total number of entries that are currently being used.|
|proc cache active||For backward compatibility only. Total number of entries that are currently being used.|
Requires membership in the sysadmin fixed server role or the db_owner fixed database role.