Displays information in a table format about the procedure cache.
DBCC PROCCACHE
SQL Server Performance Monitor uses DBCC PROCCACHE to obtain information about the procedure cache.
DBCC PROCCACHE returns this result set (values may vary):
num proc buffs num proc buffs used num proc buffs active proc cache size
-------------- ------------------- --------------------- ---------------
70 70 23 73
proc cache used proc cache active
--------------- -----------------
73 26
(1 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
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 |
DBCC PROCCACHE permissions default to members of the sysadmin fixed server role or the db_owner fixed database role, and are not transferable.
| Memory Architecture | DBCC |