BIG Istar performance problem 
Author Message
 BIG Istar performance problem

Subject:  BIG Istar performance problem.
----------------------------------------

I have a very big performance problem with Istar.

My server is an Data General AViiON 9500 (2 cpu's) with 4 OnLines. I have
2 Data General clients and 2 Pyramid MIServer clients.
There is also activity between the OnLines on the server (Istar
by usings "local host".

A simple testprogram have been created to measure times for
open database, select etc.

On the server I have 300 to 500 sqlturbo processes. No frontends
runs on the server. All frontends are version 4.10.xx and all
backends are version 5.00.xx.

If I run my test program on the server, when the load is high
without using Istar, the total used time is very low, it may
be 0.07 sec. up to 1.00 sec.

If I run my test program using Istar from the server or from one
of the clients the used time gets very bad, the time peaks up
to 190 sec. Actually it is not useful to run client server
for the normal users !

Do you have any input that might help me ?
If yes please write a mail.

Thanks from:
-----------------------------------------------------------------
Databaseadministrator Poul Pedersen
Kuwait Petroleum (Danmark) A/S

2830  Virum                               Voice:  +45 45 98 45 94
Denmark                                   Fax:    +45 42 85 14 18
-----------------------------------------------------------------



Sat, 03 Aug 1996 00:58:06 GMT
 BIG Istar performance problem

Thank Curtis for your fast responce.

Quote:
> You may wish to put a network monitor on your system during
> the testing activity.

Yes I think, that I will do that again.

Quote:
> The client/server app maybe forcing large amounts of
> data onto the network.

Some applications yes, but not my small test programs.

Thanks
-----------------------------------------------------------------
Databaseadministrator Poul Pedersen
Kuwait Petroleum (Danmark) A/S

2830  Virum                               Voice:  +45 45 98 45 94
Denmark                                   Fax:    +45 42 85 14 18
-----------------------------------------------------------------



Sat, 03 Aug 1996 04:33:07 GMT
 BIG Istar performance problem
Paul, thanks for fast response,

Quote:
>> On the server I have 300 to 500 sqlturbo processes. No frontends
>> runs on the server. All frontends are version 4.10.xx and all
>> backends are version 5.00.xx.

The slow connection with Istar is done by tcp/ip.

Quote:
>We have a Sun IPC (small, single cpu desktop) connected to an RS/6000 model
>550 via a 56K WAN circuit.  We are using 4.10.x tools and 4.10.x
>engine(s).
>The RS/6000 has 50-60 users generating 200+ sqlturbo processes.  The Sun
>has under 12 users and only 25 or so sqlturbo processes.  Neither has the
>same horsepower as your boxes!
>> If I run my test program on the server, when the load is high
>> without using Istar, the total used time is very low, it may
>> be 0.07 sec. up to 1.00 sec.
>Local processing is on the order of 1-3 seconds, I-Star processing is on
>the order of 3-6 seconds.  I would give a rough estimate of I-Star (and
>data circuit) overhead of a factor of two.

On a Pyramid MIServer I have seen an increase of up to 2 sec. with Istar.

Quote:
>I am not sure what factors are increasing your processing time by a factor
>of 190X!!

Yes that was my peak, more normal is 100X, but that does not make it better !

Quote:
>I should add that both engines are tuned very well.  The RS/6000 has about
>24 Meg of shared memory dedicated to On-Line and our table sizes are pretty
>nominal (10K to 15K records).

I think so, last time i made a tbstat -p, it showed 99.5 % read cache and
98 % write cache, the write cache may fall to 92 - 93 % and fast checkpoints
(low LRU marks) on the main OnLine. Total shared memory is 38 Mbytes.

Thanks
-----------------------------------------------------------------
Databaseadministrator Poul Pedersen
Kuwait Petroleum (Danmark) A/S

2830  Virum                               Voice:  +45 45 98 45 94
Denmark                                   Fax:    +45 42 85 14 18
-----------------------------------------------------------------



Sat, 03 Aug 1996 04:43:14 GMT
 BIG Istar performance problem
Thanks jack for your fast responce,

Quote:

>> Subject:  BIG Istar performance problem.
>> ----------------------------------------

>How are you using the istar?  Are you:

>database a


>?

>If so - we've discovered that using a DATABASE statement to point at the
>second engine is more efficient.

Yes, that is correct. The most time is used to open a database and
when that is done things works fast.

A lot of applications will select from 2 or more Onlines by using
synonyms.
A lot of applications are build up of many executeable programs, which
after load will run an open database statement.
Both are a problem - a big one when this part performs very slow.

thanks Jack
-----------------------------------------------------------------
Databaseadministrator Poul Pedersen
Kuwait Petroleum (Danmark) A/S

2830  Virum                               Voice:  +45 45 98 45 94
Denmark                                   Fax:    +45 42 85 14 18
-----------------------------------------------------------------



Sat, 03 Aug 1996 05:13:08 GMT
 BIG Istar performance problem
: Subject:  BIG Istar performance problem.
: ----------------------------------------

: I have a very big performance problem with Istar.

: My server is an Data General AViiON 9500 (2 cpu's) with 4 OnLines. I have
: 2 Data General clients and 2 Pyramid MIServer clients.
: There is also activity between the OnLines on the server (Istar
: by usings "local host".

: A simple testprogram have been created to measure times for
: open database, select etc.

: On the server I have 300 to 500 sqlturbo processes. No frontends
: runs on the server. All frontends are version 4.10.xx and all
: backends are version 5.00.xx.

: If I run my test program on the server, when the load is high
: without using Istar, the total used time is very low, it may
: be 0.07 sec. up to 1.00 sec.

: If I run my test program using Istar from the server or from one
: of the clients the used time gets very bad, the time peaks up
: to 190 sec. Actually it is not useful to run client server
: for the normal users !

: Do you have any input that might help me ?
: If yes please write a mail.

Try making a remote connection over I-Star and then either breaking
out of it or just waiting for it to finish.  Go over to another terminal
and run a netstat and see what your socket is doing.  My Pyramid exhibits
the same behavior, it holds onto a socket for about 90 seconds after the last
info is transmitted.

I've traced some bug reports on Informix-Link down to a TCP/IP parameter
called SO_LINGER, that seems to tell the socket to remain open for a certain
amount of time after the request to close it is given.

That's as far as I can get.  I'm at my limit of TCP/IP...sockets expertise.
We gave up on I-Star and are using our own homebrew tools that work better (and
also doesn't require like logging modes on both databases, BTW).  Has anyone
solved this?

: Thanks from:
: -----------------------------------------------------------------
: Databaseadministrator Poul Pedersen
: Kuwait Petroleum (Danmark) A/S

: 2830  Virum                               Voice:  +45 45 98 45 94
: Denmark                                   Fax:    +45 42 85 14 18
: -----------------------------------------------------------------

--
===========================================================================

Database Administrator                    represent my company, please send    
The Tigon Corporation                     money and I'll send you stock"
Dallas, Texas
Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall!
===========================================================================



Sat, 03 Aug 1996 14:11:03 GMT
 BIG Istar performance problem
Hello out there in informix land!

I have a question.

When cleaning up user privs for our database I cam accross some
userauth I do not understand.

What does "--*----" or "-i*----" mean?

I am also finding some auth with uppercase like "S------"

Please advise as to what they mean.

Thanks.

or post

Miriam



Sun, 04 Aug 1996 00:02:27 GMT
 BIG Istar performance problem

Quote:

>Hello out there in informix land!
>I have a question.
>When cleaning up user privs for our database I cam accross some
>userauth I do not understand.
>What does "--*----" or "-i*----" mean?
>I am also finding some auth with uppercase like "S------"

This comes from the Informix Guide to SQL - Tutorial, p. 11-9.

                              insert
         unconditional Update   |   index
                             \  |  /
     unconditional Select -  su-idxar  - references
                              /   \ \
* if column privilege granted      \ alter
                                    delete

Troy

==============================================================================
Troy L. Hewitt, CSE         INFORMIX-Federal         Client Services

------------------------------------------------------------------------------
  All opinions expressed are my own and not those of Informix Software, Inc.
==============================================================================



Sun, 04 Aug 1996 03:18:52 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Big ISTAR performance problem

2. Big Istar Performance

3. Istar to Istar connection problem

4. ISTAR/INET Performance Problem

5. NEEDED: BETTER JOIN PERFORMANCE ON BIG TABLE WITH BIG INDEXES (NESTED LOOPS AND MERGE JOINS)

6. BIG Performance Problems Accessing OLAP Cube

7. Big-time performance problem

8. Big PL/SQL Performance Problems

9. Performance problems with really big tables

10. Big Performance-Problems using ISDN

11. Big Performance-Problems using ISDN

12. Oracle 8i, SuSe Linux, big performance problem whith hot backup


 
Powered by phpBB® Forum Software