Used by SQL Performance Monitor to interrogate the procedure cache.
For additional syntax information for the DBCC command, see the Microsoft SQL Server Transact-SQL Reference.
DBCC PROCCACHE
The following values are returned:
| num proc buffs | The number of possible procedures that could be in cache. |
| num proc buffs used | The number of slots that have a procedure in them. |
| num proc buffs active | The number of slots that have a procedure in them and are executing. |
| proc cache size | The total size of the procedure cache. |
| proc cache used | The amount of procedure cache containing procedures. |
| proc cache active | The amount of procedure cache containing procedures that are executing. |
Note The size of the procedure cache can grow and shrink as other operations, such as cursors and the query parser, start.