Procedure Cache Detail (PD_PCAC)
- Organization of this page
Function
The Procedure Cache Detail (PD_PCAC) record indicates information related to a procedure cache. Only one record is created.
A procedure cache is a memory area that stores the procedure that was used most recently. It is also used for creating a procedure and compiling a query.
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
60 |
Y |
|
Collection Offset |
0 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key field
None
Lifetime
From the time a Microsoft SQL Server instance starts until the time it stops
Record size
-
Fixed part: 761 bytes
-
Variable part: 0 bytes
Fields
|
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|---|---|---|---|---|---|
|
Max Proc Buffers Active % (MAX_PROCEDURE_BUFFERS_ACTIVE_PCT) |
Maximum percentage of procedure cache slots that were used by the stored procedures being executed during the monitoring period |
-- |
double |
No |
DBCC PROCCACHE |
|
Max Proc Buffers Used % (MAX_PROCEDURE_BUFFERS_USED_PCT) |
Maximum percentage of procedure cache slots that were used during the monitoring period |
-- |
double |
No |
DBCC PROCCACHE |
|
Max Proc Cache Active % (MAX_PROCEDURE_CACHE_ACTIVE_PCT) |
Maximum percentage of procedure cache size that was used by the stored procedures being executed during the monitoring period |
-- |
double |
No |
DBCC PROCCACHE |
|
Max Proc Cache Used % (MAX_PROCEDURE_CACHE_USED_PCT) |
Maximum percentage of procedure cache size that was used during the monitoring period |
-- |
double |
No |
DBCC PROCCACHE |
|
Proc Buffers Active % (PROCEDURE_BUFFERS_ACTIVE_PCT) |
Percentage of procedure cache slots that were used by the stored procedures being executed during the monitoring period |
-- |
double |
No |
DBCC PROCCACHE |
|
Proc Buffers Used % (PROCEDURE_BUFFERS_USED_PCT) |
Percentage of procedure cache slots that were used during the monitoring period |
-- |
double |
No |
DBCC PROCCACHE |
|
Proc Cache Active % (PROCEDURE_CACHE_ACTIVE_PCT) |
Percentage of procedure cache size that was used by the stored procedures being executed during the monitoring period |
-- |
double |
No |
DBCC PROCCACHE |
|
Proc Cache Size (PROCEDURE_CACHE_SIZE) |
Total procedure cache size (in pages; 1 page equals 8 kilobytes) |
-- |
double |
No |
DBCC PROCCACHE |
|
Proc Cache Used % (PROCEDURE_CACHE_USED_PCT) |
Percentage of procedure cache size that was used during the monitoring period |
-- |
double |
No |
DBCC PROCCACHE |
|
Record Time (RECORD_TIME) |
Interval end time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always PCAC) |
-- |
char(8) |
No |
Agent Collector |
|
Start Time (START_TIME) |
Interval start time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Total Proc Buffers (TOTAL_PROCEDURE_BUFFERS) |
Number of procedure cache slots inside the procedure cache (a fixed value based on the rate of procedure cache already allocated) |
-- |
double |
No |
DBCC PROCCACHE |