onperf.....who uses it?

onperf.....who uses it?

Post by mark.scran » Sun, 13 Aug 2006 01:26:23


Gang -

I'm just curious.....any "onperf" fans? I am onsite using it for query
analysis (the xtree part that is), and would hope we don't ever get rid
of it (although I know it has been discussed many times), and would
wonder if it should be enhanced.

Any thoughts?

Mark Scranton
 
 
 

onperf.....who uses it?

Post by Southwell » Sun, 13 Aug 2006 01:53:25

We use it on occasion, for just what you are doing (esp. long-running
DSS-type jobs).

I second the call to keep, and perhaps enhance.

Years back, the X-win interface was problematic, but with the ability to
put up a cheap Linux workstation, I would even rescind my call to port
to some other type of interface (Web w/ Java plug-in?).

Enhancements? Allow me to specify items in the Activity Tools area to
monitor. E.g.: I have so many chunks that only 32 show up.

Schuyler Southwell
Software Engineer, Consulting
Maricopa County Attorney's Office
Phoenix, AZ 85003



-----Original Message-----
From: XXXX@XXXXX.COM
[mailto: XXXX@XXXXX.COM ] On Behalf Of
XXXX@XXXXX.COM
Sent: Friday, August 11, 2006 9:26 AM
To: XXXX@XXXXX.COM
Subject: onperf.....who uses it?

Gang -

I'm just curious.....any "onperf" fans? I am onsite using it for query
analysis (the xtree part that is), and would hope we don't ever get rid
of it (although I know it has been discussed many times), and would
wonder if it should be enhanced.

Any thoughts?

Mark Scranton

_______________________________________________
Informix-list mailing list
XXXX@XXXXX.COM
http://www.yqcomputer.com/

 
 
 

onperf.....who uses it?

Post by informixdb » Sun, 13 Aug 2006 01:57:47

I never use onperf but xtree is packaged separately (xtree) and I use
it all the time.
Version 10 does have onstat -g pqs that has the same information in a
character format.
Also use set explain statistics with onstat -g pqs.
Xtree stand alone is much quicker than running it from onperf and the
overhead is less.

Remove onperf from the install, but leave xtree!

FYI
 
 
 

onperf.....who uses it?

Post by Art S. Kag » Sun, 13 Aug 2006 02:01:43


Big fan of xtree. I find the rest of onperf unneccessarily limited.
CobraSonic's DBSonar and AGS's full version of Server Studio do a better job
of displaying/monitoring resources.

On a separate note, good to be hearing from again you Mark.

Art S. Kagel
 
 
 

onperf.....who uses it?

Post by Darren_Jac » Sun, 13 Aug 2006 02:26:41

yes, I use xtree all the time. I find it very valuable. I've also used
the monitor to watch cpu utilization during load testing, disk i/o, isam
calls, etc..

Enchancement would be great. Specifically, tabinfo (tabid maybe) in the
query tree display.

Thanks




"mark.scranton@gm
ail.com"
<mark.scranton@gm To
ail.com> XXXX@XXXXX.COM
Sent by: cc
informix-list-bou
XXXX@XXXXX.COM Subject
onperf.....who uses it?

08/11/2006 12:26
PM







Gang -

I'm just curious.....any "onperf" fans? I am onsite using it for query
analysis (the xtree part that is), and would hope we don't ever get rid
of it (although I know it has been discussed many times), and would
wonder if it should be enhanced.

Any thoughts?

Mark Scranton

_______________________________________________
Informix-list mailing list
XXXX@XXXXX.COM
http://www.yqcomputer.com/
 
 
 

onperf.....who uses it?

Post by Paul Watso » Sun, 13 Aug 2006 02:32:20

I haven't used it for a while due to lack of X - but when it is
available then I use it alot


Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com

GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 European Conference.
Vienna, Austria. 2-6 October 2006
Visit http://www.yqcomputer.com/



-----Original Message-----
From: XXXX@XXXXX.COM [mailto: XXXX@XXXXX.COM ]
Posted At: 11 August 2006 11:26
Posted To: comp.databases.informix
Conversation: onperf.....who uses it?
Subject: onperf.....who uses it?


Gang -

I'm just curious.....any "onperf" fans? I am onsite using it for query
analysis (the xtree part that is), and would hope we don't ever get rid
of it (although I know it has been discussed many times), and would
wonder if it should be enhanced.

Any thoughts?

Mark Scranton
 
 
 

onperf.....who uses it?

Post by davi » Sun, 13 Aug 2006 06:04:39


I have used xtree a lot. I remember talking to Marco Greco of IBM UK
and
he said "does it still ship I though we dropped it years ago!".

Yes it does and it would be nice if xtree could display table names but
apparently
(an my memory is *** here) Marco said something like the layer that
xtree displays
and the table names layer in the engine are deliberately seperated and
there is
a kind of deliberate "wall" between the 2 layers. Pity since xtree is
good for
watch queries execute!

the
sql layer and the table layer in the engine have a
 
 
 

onperf.....who uses it?

Post by Superboe » Wed, 16 Aug 2006 02:38:10

my 2 0.01

Lack of X: Get linux !!

onperf, xtree and oncockpit are great tools.
unfortunatly oncockpit is not available on all,


Superboer


Paul Watson schreef:
 
 
 

onperf.....who uses it?

Post by Paul Watso » Wed, 16 Aug 2006 02:41:54

And if the client won't let you ????



Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com

GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 European Conference.
Vienna, Austria. 2-6 October 2006
Visit http://www.yqcomputer.com/



-----Original Message-----
From: Superboer [mailto: XXXX@XXXXX.COM ]
Posted At: 14 August 2006 12:38
Posted To: comp.databases.informix
Conversation: onperf.....who uses it?
Subject: Re: onperf.....who uses it?


my 2 0.01

Lack of X: Get linux !!

onperf, xtree and oncockpit are great tools.
unfortunatly oncockpit is not available on all,


Superboer


Paul Watson schreef:
 
 
 

onperf.....who uses it?

Post by Colin Daws » Tue, 22 Aug 2006 23:34:14


Does it work on Solaris now?


Regards

Colin

There are 10 types of people in the world, those that understand binary and
those that don't






_________________________________________________________________
Be the first to hear what's new at MSN - sign up to our free newsletters!
http://www.yqcomputer.com/
 
 
 

onperf.....who uses it?

Post by Art S. Kag » Wed, 23 Aug 2006 00:00:22


Works for me...

Art S. Kagel
 
 
 

onperf.....who uses it?

Post by Art S. Kag » Wed, 23 Aug 2006 00:00:22


Works for me...

Art S. Kagel