Check the information about the procedure cache in SQL Server

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.