Sample output

Procedure Cache Management       per sec      per xact      count   % of total
--------------------------  ------------   -----------  ---------   --------- 
  Procedure Requests                14.2           0.3       8499         n/a
  Procedure Reads from Disk          0.0           0.0         27         0.6%
  Procedure Writes to Disk           0.0           0.0          0         0.0%
  Procedure Removals                 0.0           0.0          0         n/a
  Procedure Recompilations           0.0           0.0          0         n/a

SQL Statement Cache:
  Statements Cached                  0.6           2.7        171         n/a
  Statements Found in Cache          2.0           9.5       1529         n/a
  Statements Not Found               0.6           2.7        171         n/a
  Statements Dropped                 0.2           0.8         52         n/a
  Statements Restored                0.0           0.0          0         n/a
  Statements Not Cached              0.0           0.0          0         n/a 

The procedure cache contains most execution plans for requested procedures. In this example, the procedure cache reads only 0.6 percent from disk.

This system’s statement cache is effective, since the value for Statements Found in Cache is 611. This value is much higher than the values for Statements Not Found and Statements Cached, so the reuse rate of statements is high.