Export (0) Print
Expand All

DBCC PROCCACHE

SQL Server 2000

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.

See Also

DBCC

Memory Architecture

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft