Displays information in a table format about the procedure cache.
SQL Server Performance Monitor uses DBCC PROCCACHE to obtain information about the procedure cache.
This table describes the columns of the result set.
|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.