Problem: Retrieving parameters for Adaptive Server Enterprise stored procedures you are running or debugging is very slow.
Resolution: Increase the size of the procedure cache. The default procedure cache size increased from about 3KB in Adaptive Server Enterprise 12.5.x to 7KB in 15.0. Depending on the number of procedures you are running during a session, you may need to use sp_configure to set a larger procedure cache size than the default.
To see how much memory you are using currently, enter: sp_configure "procedure cache size"
To set the size, enter: sp_configure "procedure cache size", new_size
You may also need to set other configuration parameters to tune Adaptive Server Enterprise performance.
"Setting Configuration Parameters" in System Administration Guide: Volume 1, in the Adaptive Server Enterprise collection.
"Procedure cache" in Performance and Tuning: Basics, in the Adaptive Server Enterprise collection.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com