procedure cache size

procedure cache size specifies the size of the procedure cache, in 2K pages.

Summary Information

Default value

7000

Range of values

7000 – 2147483647

Status

Dynamic

Display level

Basic

Required role

System administrator

Configuration groups

Memory Use, SQL Server Administration

SAP ASE uses the procedure cache while running stored procedures. If the server finds a copy of a procedure already in the cache, it does not need to read it from the disk. SAP ASE also uses space in the procedure cache to compile queries while creating stored procedures.

Since the optimum value for procedure cache size differs from application to application, resetting it may improve SAP ASE performance. For example, if you run many different procedures or ad hoc queries, your application uses the procedure cache more heavily, so you may want to increase this value.

Warning!   If procedure cache size is too small, SAP ASE performance degrades.

If you are upgrading, procedure cache size is set to the size of the original procedure cache at the time of upgrade.