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.
If you are upgrading, procedure cache size is set to the size of the original procedure cache at the time of upgrade.