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 |
Specifies the size of the procedure cache, in 2K pages. Adaptive Server 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. Adaptive Server 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 Adaptive Server 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, Adaptive Server performance degrades.
If you are upgrading, procedure cache size is set to the size of the original procedure cache at the time of upgrade.
