poor performance with 7.31.ud2 
Author Message
 poor performance with 7.31.ud2

Hi all....

We just upgraded a bunch of servers from 7.30 to 7.31.ud2 and are now
witnessing poor performance that degrades over time after a reboot.

We have done all of the things that 'should' be done, update statistics,
drop and rebuild all indexes, export, drop, and import the db all to no
avail.

I am wondering if there is some sort of issue with indexes degrading quickly
with 7.31 that I haven't heard about. We are considering rebuilding the
indexs with free space set to 25%.

Does anyone have any experience with this upgrade?

Thanks,

Doug McAllister



Mon, 21 Jun 2004 04:46:06 GMT
 poor performance with 7.31.ud2

On Wed, 2 Jan 2002 15:46:06 -0500, "Doug McAllister"

Quote:

>Hi all....

>We just upgraded a bunch of servers from 7.30 to 7.31.ud2 and are now
>witnessing poor performance that degrades over time after a reboot.

>We have done all of the things that 'should' be done, update statistics,
>drop and rebuild all indexes, export, drop, and import the db all to no
>avail.

>I am wondering if there is some sort of issue with indexes degrading quickly
>with 7.31 that I haven't heard about. We are considering rebuilding the
>indexs with free space set to 25%.

>Does anyone have any experience with this upgrade?

Generally, I believe this is a good port. What hardware / OS? Have you
set NOAGE 1?


Mon, 21 Jun 2004 19:35:31 GMT
 poor performance with 7.31.ud2
LRUAGE 1


Quote:
> On Wed, 2 Jan 2002 15:46:06 -0500, "Doug McAllister"

> >Hi all....

> >We just upgraded a bunch of servers from 7.30 to 7.31.ud2 and are now
> >witnessing poor performance that degrades over time after a reboot.

> >We have done all of the things that 'should' be done, update statistics,
> >drop and rebuild all indexes, export, drop, and import the db all to no
> >avail.

> >I am wondering if there is some sort of issue with indexes degrading
quickly
> >with 7.31 that I haven't heard about. We are considering rebuilding the
> >indexs with free space set to 25%.

> >Does anyone have any experience with this upgrade?

> Generally, I believe this is a good port. What hardware / OS? Have you
> set NOAGE 1?



Tue, 22 Jun 2004 04:37:34 GMT
 poor performance with 7.31.ud2
I think that the problem that you have is related to mix of your
buffer cash.
In 7.30 there is an env variable that you suppose to set NOLRUPRIOR
than there is no priority to index pages in cash otherwise the cash
becomes full of index pages. In 7.31 there is additional variable
NOLRUAGE that may better fit

Nati Kufra

On Wed, 2 Jan 2002 15:46:06 -0500, "Doug McAllister"

Quote:

>Hi all....

>We just upgraded a bunch of servers from 7.30 to 7.31.ud2 and are now
>witnessing poor performance that degrades over time after a reboot.

>We have done all of the things that 'should' be done, update statistics,
>drop and rebuild all indexes, export, drop, and import the db all to no
>avail.

>I am wondering if there is some sort of issue with indexes degrading quickly
>with 7.31 that I haven't heard about. We are considering rebuilding the
>indexs with free space set to 25%.

>Does anyone have any experience with this upgrade?

>Thanks,

>Doug McAllister



Tue, 22 Jun 2004 04:31:16 GMT
 poor performance with 7.31.ud2
Nati schrieb:

Quote:

> I think that the problem that you have is related to mix of your
> buffer cash.
> In 7.30 there is an env variable that you suppose to set NOLRUPRIOR
> than there is no priority to index pages in cash otherwise the cash
> becomes full of index pages. In 7.31 there is additional variable
> NOLRUAGE that may better fit

> Nati Kufra

> On Wed, 2 Jan 2002 15:46:06 -0500, "Doug McAllister"

> >Hi all....

> >We just upgraded a bunch of servers from 7.30 to 7.31.ud2 and are now
> >witnessing poor performance that degrades over time after a reboot.

> >We have done all of the things that 'should' be done, update statistics,
> >drop and rebuild all indexes, export, drop, and import the db all to no
> >avail.

> >I am wondering if there is some sort of issue with indexes degrading quickly
> >with 7.31 that I haven't heard about. We are considering rebuilding the
> >indexs with free space set to 25%.

> >Does anyone have any experience with this upgrade?

> >Thanks,

> >Doug McAllister

Not completely correct, there are NOLRUPRIO and LRUAGE.
Both are environment vars to set to "1" on the shell where you start the
informix engine.
But you must not use both at the same time.
NOLRUPRIO gives read and buffered index pages always the lowest priority
available, so they can be pushed out of the buffer cache easily.
LRUAGE causes the index pages to be altered and lowered in priority by
time.

I have better experience with LRUAGE for server 7.31.* on different
platforms (ReliantUnix, Solaris, UnixWare).

You can check if it works with "onstat -R". Value for priority
downgrades should become greater than zero after some work.

Regards
Frank



Tue, 22 Jun 2004 05:20:57 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. (2) Poor Performance with 7.31.uc6

2. Poor Performance with 7.31.uc6

3. 7.31.UD2 enhancements?

4. 7.31.UD2 enhancements?

5. Quality Hold on 7.31.UD2 on Solaris?

6. Restoring 7.31.UC2XA to 7.31.FD4

7. online 7.31.ud1 vs 7.31.fd1

8. Problems joining a numeric(31,0) column with a varchar(31) column

9. SQL7 and indexing. Poor selection Poor performance

10. Performance Issues Using Windows 2000 server ans IDS 7.31.TD1

11. Informix 7.31.FC7 Performance Problems

12. What's difference between IDS 7.31.UC6AX7 and 7.31.FC7XE1 ?


 
Powered by phpBB® Forum Software