DBCC PROCCACHE in Microsoft SQL Server

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.