Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

wait for object to be returned to pool

6 posts in General Discussion Last posting was on 2010-07-16 13:31:26.0Z
Robert Densmore Posted on 2010-07-14 00:00:49.0Z
From: Robert Densmore <bdensmore@austin.rr.ignore.com>
Newsgroups: sybase.public.ase.general
Subject: wait for object to be returned to pool
Message-ID: <o5vp36ho20v6eu376hgsk6oh5u05264a2e@4ax.com>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 13 Jul 2010 17:00:49 -0700
X-Trace: forums-1-dub 1279065649 10.22.241.152 (13 Jul 2010 17:00:49 -0700)
X-Original-Trace: 13 Jul 2010 17:00:49 -0700, vip152.sybase.com
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29360
Article PK: 78592

I need some help is figuring out why this wait event is slowing down
the database. Over a 5 sec interval I see this event showing with 2-3
sec wait time. From sp_monitorconfig I don't see anyting that needs
adjusting. There are no metadata configs that need adjusting. What
else can cause this wait event?

Bob


J Posted on 2010-07-14 16:49:37.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: wait for object to be returned to pool
Reply-To: J@bogusemailAddress.com
Message-ID: <4c3dea60.9918328@forums.sybase.com>
References: <o5vp36ho20v6eu376hgsk6oh5u05264a2e@4ax.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 14 Jul 2010 09:49:37 -0700
X-Trace: forums-1-dub 1279126177 10.22.241.152 (14 Jul 2010 09:49:37 -0700)
X-Original-Trace: 14 Jul 2010 09:49:37 -0700, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29364
Article PK: 78596

On 13 Jul 2010 17:00:49 -0700, Robert Densmore
<bdensmore@austin.rr.ignore.com> wrote:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00848.1502/html/monitor_tables/CHDECJFB.htm

Event 157 occurs when a process must wait for memory to become
available before allocating the object's data.

J

>I need some help is figuring out why this wait event is slowing down
>the database. Over a 5 sec interval I see this event showing with 2-3
>sec wait time. From sp_monitorconfig I don't see anyting that needs
>adjusting. There are no metadata configs that need adjusting. What
>else can cause this wait event?
>
>Bob
>
>


Robert Densmore Posted on 2010-07-14 22:18:11.0Z
From: Robert Densmore <bdensmore@austin.rr.ignore.com>
Newsgroups: sybase.public.ase.general
Subject: Re: wait for object to be returned to pool
Message-ID: <1jds36t0kevpbnifkhhf53mnv1vrikfdqi@4ax.com>
References: <o5vp36ho20v6eu376hgsk6oh5u05264a2e@4ax.com> <4c3dea60.9918328@forums.sybase.com>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 14 Jul 2010 15:18:11 -0700
X-Trace: forums-1-dub 1279145891 10.22.241.152 (14 Jul 2010 15:18:11 -0700)
X-Original-Trace: 14 Jul 2010 15:18:11 -0700, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29367
Article PK: 78601

Yes, I read that. I was looking for some additional information as to
which memory.

In the meantime, I figured this out. It has to do with auditing. The
login I used had sso role and auditing is configured to audit
everyting with sso role. This wait event relates, in my situation, to
auditing. If I turn auditing off, this wait event disappears. If I
increase audit queue size, this seems to have no effect. The long
wait times still appear. If I use an account that doesn't appear in
the audit configuration, the wait events disappear.

So, even with a large audit queue size, auditing has a tremendous
impact.

Bob

On 14 Jul 2010 09:49:37 -0700, jtotally_bogus@sbcglobal.net (J) wrote:

>On 13 Jul 2010 17:00:49 -0700, Robert Densmore
><bdensmore@austin.rr.ignore.com> wrote:
>
>http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00848.1502/html/monitor_tables/CHDECJFB.htm
>
>Event 157 occurs when a process must wait for memory to become
>available before allocating the object's data.
>
>J
>
>>I need some help is figuring out why this wait event is slowing down
>>the database. Over a 5 sec interval I see this event showing with 2-3
>>sec wait time. From sp_monitorconfig I don't see anyting that needs
>>adjusting. There are no metadata configs that need adjusting. What
>>else can cause this wait event?
>>
>>Bob
>>
>>


Rob V [ Sybase ] Posted on 2010-07-15 22:49:18.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.4) Gecko/20100608 Thunderbird/3.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: wait for object to be returned to pool
References: <o5vp36ho20v6eu376hgsk6oh5u05264a2e@4ax.com> <4c3dea60.9918328@forums.sybase.com> <1jds36t0kevpbnifkhhf53mnv1vrikfdqi@4ax.com>
In-Reply-To: <1jds36t0kevpbnifkhhf53mnv1vrikfdqi@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c3f906e@forums-1-dub>
Date: 15 Jul 2010 15:49:18 -0700
X-Trace: forums-1-dub 1279234158 10.22.241.152 (15 Jul 2010 15:49:18 -0700)
X-Original-Trace: 15 Jul 2010 15:49:18 -0700, vip152.sybase.com
Lines: 98
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29368
Article PK: 78599

That's a useful finding; I need to remember this...

Thanks for sharing,

Rob V.

On 15-Jul-10 00:18, Robert Densmore wrote:
> Yes, I read that. I was looking for some additional information as to
> which memory.
>
> In the meantime, I figured this out. It has to do with auditing. The
> login I used had sso role and auditing is configured to audit
> everyting with sso role. This wait event relates, in my situation, to
> auditing. If I turn auditing off, this wait event disappears. If I
> increase audit queue size, this seems to have no effect. The long
> wait times still appear. If I use an account that doesn't appear in
> the audit configuration, the wait events disappear.
>
> So, even with a large audit queue size, auditing has a tremendous
> impact.
>
> Bob
>
> On 14 Jul 2010 09:49:37 -0700, jtotally_bogus@sbcglobal.net (J) wrote:
>
>> On 13 Jul 2010 17:00:49 -0700, Robert Densmore
>> <bdensmore@austin.rr.ignore.com> wrote:
>>
>> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00848.1502/html/monitor_tables/CHDECJFB.htm
>>
>> Event 157 occurs when a process must wait for memory to become
>> available before allocating the object's data.
>>
>> J
>>
>>> I need some help is figuring out why this wait event is slowing down
>>> the database. Over a 5 sec interval I see this event showing with 2-3
>>> sec wait time. From sp_monitorconfig I don't see anyting that needs
>>> adjusting. There are no metadata configs that need adjusting. What
>>> else can cause this wait event?
>>>
>>> Bob
>>>
>>>

--
Dear Sybase user,

I am currently unable to respond to the specific question(s) which you have sent me. Due to the ever increasing number of questions I am receiving, I currently simply don't have the time to answer detailed individual questions.
Please post your question to one of the ASE-related newsgroups so that the ASE community can participate/benefit.
These newsgoups are comp.databases.sybase (Usenet), as well as various newsgroups on Sybase's own news server (forums.sybase.com).
Also, please provide sufficient technical details (error messages, actual queries, query plans, etc.) about your problem.
Try the Sybase FAQ at http://www.isug.com/Sybase_FAQ/, which contains answers to many questions about ASE.

Kind regards,

Rob Verschoor

If you don't want to use X Windows, you could try "sybinit4ever", a free tool which uses only an ASCII interface to create a new ASE server. It can be downloaded from http://www.sypron.nl/si4evr.html

See the
ASE reference manual / System Administration Guide / Transact-SQL user's guide
This / These books can be viewed or downloaded as PDF files from the Sybase website http://www.sybase.com/support/manuals/ . For more details how to get there, see http://www.sypron.nl/sybbooks.html .

For more information on the background of this problem, as well as a solution, see http://www.sypron.nl/idgaps.html .

... syntax and description are in the ASE Quick Reference Supplement, which you can download from http://www.sypron.nl/ase_qref.html (for a better version, see my book -- www.sypron.nl/qr).


To use dynamic SQL, you need at least ASE version 12.0, which has the "execute immediate" feature for this. In earlier versions of ASE you can simulate some types of dynamic SQL though; for more information, see http://www.sypron.nl/dynsql.html and http://www.sypron.nl/dynsqlcis.html .

For more information about Sybase Certification Exams, see http://www.sypron.nl/certtips.html .

The ASE Performance and Tuning Guide contains a lot fo info about this topic. You can download this manual from http://sybooks.sybase.com/as.html .

HTH,

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

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

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

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------


Carl Kayser Posted on 2010-07-16 10:14:01.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <o5vp36ho20v6eu376hgsk6oh5u05264a2e@4ax.com> <4c3dea60.9918328@forums.sybase.com> <1jds36t0kevpbnifkhhf53mnv1vrikfdqi@4ax.com>
Subject: Re: wait for object to be returned to pool
Lines: 32
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c4030e9$1@forums-1-dub>
Date: 16 Jul 2010 03:14:01 -0700
X-Trace: forums-1-dub 1279275241 10.22.241.152 (16 Jul 2010 03:14:01 -0700)
X-Original-Trace: 16 Jul 2010 03:14:01 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29372
Article PK: 78604


"Robert Densmore" <bdensmore@austin.rr.ignore.com> wrote in message
news:1jds36t0kevpbnifkhhf53mnv1vrikfdqi@4ax.com...
> Yes, I read that. I was looking for some additional information as to
> which memory.
>
> In the meantime, I figured this out. It has to do with auditing. The
> login I used had sso role and auditing is configured to audit
> everyting with sso role. This wait event relates, in my situation, to
> auditing. If I turn auditing off, this wait event disappears. If I
> increase audit queue size, this seems to have no effect. The long
> wait times still appear. If I use an account that doesn't appear in
> the audit configuration, the wait events disappear.
>
> So, even with a large audit queue size, auditing has a tremendous
> impact.
>
> Bob
>

Curious. Usually it's the SA role that is audited to the hilt. With SSO
one could possibly just audit the SPs targeted for SSOs instead of "SSO
everything".

Not to do directly with your issue but, reading between the lines, it seems
that you might be saying that auditing of a login/role is more resource
intensive than auditing objects (procs, triggers, create index, etc). Or do
I have an incorrect perspective?

(SNIP)


Robert Densmore Posted on 2010-07-16 13:31:26.0Z
From: Robert Densmore <bdensmore@austin.rr.ignore.com>
Newsgroups: sybase.public.ase.general
Subject: Re: wait for object to be returned to pool
Message-ID: <23n0461328a94lk17og46vkbci2e1b9k0l@4ax.com>
References: <o5vp36ho20v6eu376hgsk6oh5u05264a2e@4ax.com> <4c3dea60.9918328@forums.sybase.com> <1jds36t0kevpbnifkhhf53mnv1vrikfdqi@4ax.com> <4c4030e9$1@forums-1-dub>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 16 Jul 2010 06:31:26 -0700
X-Trace: forums-1-dub 1279287086 10.22.241.152 (16 Jul 2010 06:31:26 -0700)
X-Original-Trace: 16 Jul 2010 06:31:26 -0700, vip152.sybase.com
Lines: 54
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29373
Article PK: 78605

Yes, I'm saying that auditing of an entire role/login is more resource
intensive. I was simulating our application processes (using multiple
spids, say 20-30), which hits alot of tables/triggers/procs/etc., so
alot of activity was being sent to audit logs, and this wait event was
the one event slowing my simulation down alot.

Our Data Center has configured auditing for sa role, sso role, and
account login and account logout. (I think from their perspective,
that was the easiest to do, instead of auditing specific sso used
procs).

To simulate better our application processes and looking for
performance issues, I needed to move to a login that did not have
sa_role or sso_role. It took me quite a while to figure this one out.

I even increased audit queue size tremendously, and that didn't seem
to have an effect on reducing this wait event.

Bob

On 16 Jul 2010 03:14:01 -0700, "Carl Kayser" <kayser_c@bls.gov> wrote:

>
>"Robert Densmore" <bdensmore@austin.rr.ignore.com> wrote in message
>news:1jds36t0kevpbnifkhhf53mnv1vrikfdqi@4ax.com...
>> Yes, I read that. I was looking for some additional information as to
>> which memory.
>>
>> In the meantime, I figured this out. It has to do with auditing. The
>> login I used had sso role and auditing is configured to audit
>> everyting with sso role. This wait event relates, in my situation, to
>> auditing. If I turn auditing off, this wait event disappears. If I
>> increase audit queue size, this seems to have no effect. The long
>> wait times still appear. If I use an account that doesn't appear in
>> the audit configuration, the wait events disappear.
>>
>> So, even with a large audit queue size, auditing has a tremendous
>> impact.
>>
>> Bob
>>
>
>Curious. Usually it's the SA role that is audited to the hilt. With SSO
>one could possibly just audit the SPs targeted for SSOs instead of "SSO
>everything".
>
>Not to do directly with your issue but, reading between the lines, it seems
>that you might be saying that auditing of a login/role is more resource
>intensive than auditing objects (procs, triggers, create index, etc). Or do
>I have an incorrect perspective?
>
>(SNIP)
>