DBCC PROCCACHE
Displays information in a table format about the procedure cache.
Syntax
DBCC PROCCACHE
Remarks
SQL Server Performance Monitor uses DBCC PROCCACHE to obtain information about the procedure cache.
Result Sets
This table describes the columns of the result set.
| Column name | Description |
|---|---|
| num proc buffs | Number of possible stored procedures that could be in the procedure cache. |
| num proc buffs used | Number of cache slots holding stored procedures. |
| num proc buffs active | Number of cache slots holding stored procedures that are currently executing. |
| proc cache size | Total size of the procedure cache. |
| proc cache used | Amount of the procedure cache holding stored procedures. |
| proc cache active | Amount of the procedure cache holding stored procedures that are currently executing. |
Permissions
DBCC PROCCACHE permissions default to members of the sysadmin fixed server role or the db_owner fixed database role, and are not transferable.