.png)
DBCC PROCCACHE (Transact-SQL)
Displays information in a table format about the procedure cache.
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 SQL Server Performance Monitor uses DBCC PROCCACHE to obtain information about the procedure cache.
The following table describes the columns of the result set.
|
Column name |
Description |
|---|---|
|
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. |
