Resource governor for prepared statement exceeded

Peter Kolmisoppi

unread,

Mar 9, 1999, 3:00:00 AM3/9/99

to

"Resource governor for prepared statement exceeded"

Anybody recognize this fault from Sybase Central? Happens when you press
F5 to reload.. (you have to press a couple of times fast).. and only for
us when we've started a database by hand with "start database" with
"autostop no".

Can anybody explain?

Thanks
Peter
Media Svar AB
+46-511-10000

Jason Hinsperger

unread,

Mar 9, 1999, 3:00:00 AM3/9/99

to

This error occurs when a certain number of statements (50 by default) are
prepared and not freed.
This indicates a bug in Sybase Central. It is preparing statements and not
freeing them.
This problem has been fixed in the upcoming 6.0.02 maintenance release.
To head of your response: No, I don't know when it will be available.

Jason Hinsperger
Product Quality
Adaptive Server Anywhere

Breck Carter

unread,

Mar 9, 1999, 3:00:00 AM3/9/99

to

Peter Kolmisoppi <pe...@mediasvar.se> wrote:

>"Resource governor for prepared statement exceeded"
>
>Anybody recognize this fault from Sybase Central? Happens when you press
>F5 to reload.. (you have to press a couple of times fast).. and only for
>us when we've started a database by hand with "start database" with
>"autostop no".
>
>Can anybody explain?
>
>Thanks
>Peter
>Media Svar AB
>+46-511-10000

I can't explain, but I'll take a WAG... try this from DBISQL:

SET OPTION PUBLIC.MAX_STATEMENT_COUNT = 0

To see all the current options, execute this from DBISQL:

SET

The MAX_STATEMENT_COUNT = 0 turns off the "resource governor" that
limits the number of prepared statements that can be used at one time
by one connection. Why Sybase Central would blow the default limit of
50 is anyone's guess :)

Breck

Peter Kolmisoppi

unread,

Mar 9, 1999, 3:00:00 AM3/9/99

to

We are experiencing loads of troubles with ASA - like the speed. Our MS-SQL 6.5
server running with a Pentium pro processor with 512megs of RAM is just as fast
as our Dualprocessor Sun Enterprise 450 with 1 gigs of RAM. Very weird, and the
only thing we've done is that we installed ASA. Do you have any ideas what this
can be? Also; where on the web do i get the EBFs? I've searched for EBF 1254 on
the support.sybase.com site, but I couldn't find any. Is there an e-mail adress
or similar?

// Peter

Jason Hinsperger skrev:

> This error occurs when a certain number of statements (50 by default) are
> prepared and not freed.
> This indicates a bug in Sybase Central. It is preparing statements and not
> freeing them.
> This problem has been fixed in the upcoming 6.0.02 maintenance release.
> To head of your response: No, I don't know when it will be available.
>
> Jason Hinsperger
> Product Quality
> Adaptive Server Anywhere
>

Breck Carter

unread,

Mar 9, 1999, 3:00:00 AM3/9/99

to

You are not alone. Rumor has it that 6.0.02 will address the issue of
performance. Don't ask me "when?", though, because I'd have to answer,
"real soon, I hope!"

Breck

Peter Kolmisoppi

unread,

Mar 9, 1999, 3:00:00 AM3/9/99

to

It's fast on selects and similar, but slow on inserts/updates..
wieeeeeeerd..

// Peter

Breck Carter skrev:

Jim Egan

unread,

Mar 9, 1999, 3:00:00 AM3/9/99

to

Don't keep hitting that button! <g> I've seen this in Sybase Central and
I turned in a bug report on it.

You can probably reduce the problem by increasing the governor values
through the SET command. See the online help for the syntax for the two
governor values.
--
Jim Egan [TeamPS]
Dynamic Data Solutions, Inc. http://www.dyn-data.com
Houston, TX

***********************************************************
Enterprise Applications in Your Future?
JumpStart '99 Enterprise Solutions Conference
http://www.JumpStart99.com
***********************************************************