Hi

This week we installed Sybase ASE 15 Small Business Edition on a Windows
2003 server with 2GB RAM.
Now we notice we're having some problems when running certain procedures, we
get the following error message:
"There is not enough procedure cache to run this procedure, trigger, or SQL
Batch. Retry later, or ask you SA to reconfigure SQL Server with more
procedure cache."
SQLState returns 'ZZZZZ'

We've configured the server's memory as follows:
"Allocate Max Shared Memory" = 1
"Max Memory" = 1024M
"Procedure Cache Size" = 200M
"Default data cache" = 600M

The database we loaded on the ASE 15 came from a 12.5.1 server with the
following settings
"Allocate Max Shared Memory" = 0
"Max Memory" = 256M
"Procedure Cache Size" = 37M
"Default data cache" = 137M

On the old server we never had any problems with the procedure cache or with
memory altogether. I've tried increasing the procedure cache on the new
server up to 300M but I still get the same error.
Is something wrong about the configuration I posted above? Is there some
other configuration setting I have to change?
If anyone has any ideas please let me hear them, I'd be surprised if a 200M
procedure cache on ASE15 is insufficient where a 37M procedure cache as
sufficient on ASE 12.5.1

Regards
Kristof Baute
Tauris bvba

what does "sp_monitorconfig 'all'" show for reuse of "number of open objects"?

exec sp_monitorconfig 'number of open objects'
or
exec sp_monitorconfig 'all'


Sometimes, error 701 can occur because of reaching the maximum number of open
objects, and des scavenging.

"Baute Kristof" <kristof.baute (AT) tauris (DOT) be> wrote

Hi

This is the output for sp_monitorconfig 'all', the procedure cache and the
open objects seem fine to me, anything else that looks abnormal?

Name Num_free Num_active Pct_act Max_Used
Num_Reuse
------------------------- ----------- ----------- ------- ----------- -----------
additional network memory 550716 1649376 74.97 1649376 0
audit queue size 100 0 0.00 0 0
disk i/o structures 256 0 0.00 240 0
heap memory per user 4096 0 0.00 0 0
max cis remote connection 800 0 0.00 0 0
max memory 0 524288 100.00 524288 0
max number network listen 4 1 20.00 1 0
max online engines 0 1 100.00 1 0
memory per worker process 1024 0 0.00 0 0
number of alarms 27 13 32.50 14 0
number of aux scan descri 256 0 0.00 0 0
number of devices 26 14 35.00 14 0
number of dtx participant 500 0 0.00 0 0
number of java sockets 217 0 0.00 0 0
number of large i/o buffe 6 0 0.00 1 0
number of locks 4679 321 6.42 367 0
number of mailboxes 29 1 3.33 1 0
number of messages 64 0 0.00 0 0
number of open databases 3 9 75.00 9 0
number of open indexes 405 595 59.50 596 0
number of open objects 1785 215 10.75 215 0
number of open partitions 405 595 59.50 596 0
number of remote connecti 20 0 0.00 1 0
number of remote logins 20 0 0.00 0 0
number of remote sites 10 0 0.00 1 0
number of sort buffers 500 0 0.00 66 0
number of user connection 190 10 5.00 11 0
number of worker processe 0 0 0.00 0 0
partition groups 1024 0 0.00 0 0
permission cache entries 15 0 0.00 0 60
procedure cache size 99871 2529 2.47 2818 0
size of global fixed heap 150 0 0.00 0 0
size of process object he 1500 0 0.00 0 0
size of shared class heap 1536 0 0.00 0 0
size of unilib cache 279248 4096 1.45 4096 0
txn to pss ratio 3200 0 0.00 0 0
Usage information at date and time: Jun 29 2006 8:53AM.

Execution time: 0.141 seconds

Kristof Baute
Tauris bvba

"Sherlock, Kevin" <ksherlock (AT) saionline (DOT) com> wrote

Has your ASE server been rebooted since you've seen the 701 error?

"Baute Kristof" <kristof.baute (AT) tauris (DOT) be> wrote

Yes, the server has been restarted but there were no changes. The error is
still there.

"Sherlock, Kevin" <ksherlock (AT) saionline (DOT) com> wrote

Which *exact* 15. version are you running? 15.0 esd#2 has solved a bunch of
issues in this area and I would strongly recommend using that instead of
earlier EBFs.

HTH,

Rob V.
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Baute Kristof" <kristof.baute (AT) tauris (DOT) be> wrote

@@version returns the following:

Adaptive Server Enterprise/15.0/EBF 13448 ESD#2/P/NT (IX86)/Windows
2000/ase150/2193/32-bit/OPT/Wed May 17 16:43:17 2006


"Rob Verschoor" <rob (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
message news:44a50cf7 (AT) forums-2-dub (DOT) ..

Hmmm.. thanks for the info. I'd like to learn more about this, and I'll
contact you offline for that.

HTH,

Rob V.


"Baute Kristof" <kristof.baute (AT) tauris (DOT) be> wrote