DBCC PROCCACHE (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
Displays information in a table format about the procedure cache.
Transact-SQL syntax conventions
Syntax
DBCC PROCCACHE [ WITH NO_INFOMSGS ]
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
WITH
Allows for options to be specified.
NO_INFOMSGS
Suppresses all informational messages that have severity levels 0 through 10.
Remarks
The procedure cache is used to cache the compiled and executable plans to speed up the execution of batches. The entries in a procedure cache are at a batch level. The procedure cache includes the following entries:
- Compiled plans
- Execution plans
- Algebrizer tree
- Extended procedures
Result sets
The following table describes the columns of the result set.
Column name | Description |
---|---|
num proc buffs | Total number of pages used by all entries in the procedure cache. |
num proc buffs used | Total number of pages used by all entries that are currently being used. |
num proc buffs active | For backward compatibility only. Total number of pages used by all entries that are currently being used. |
proc cache size | Total number of entries in the procedure cache. |
proc cache used | Total number of entries that are currently being used. |
proc cache active | For backward compatibility only. Total number of entries that are currently being used. |
Permissions
Requires membership in the sysadmin fixed server role or the db_owner fixed database role.
See also
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru