onperf.....who uses it?
Posted in 2006
Not a problem report but an opinion poll: Mark Scranton asked who still uses onperf, especially its xtree query-visualisation component, and whether it should be enhanced. Replies were broadly positive about xtree (used for watching long DSS queries), while several felt the rest of onperf was limited compared with tools like DBSonar or Server Studio, or suggested onstat -g pqs plus SET EXPLAIN as a character-mode alternative. Wish-list items included showing table names/tabid in the query tree and monitoring more chunks; one poster recalled that an internal separation between engine layers makes table names hard to surface. X-Windows availability was noted as a practical obstacle. No technical issue was resolved.
Topics: General Discussion
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
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: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of mark.scranton@gmail.com Sent: Friday, August 11, 2006 9:26 AM To: informix-list@iiug.org 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 Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
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
mark.scranton@gmail.com wrote:
> 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
mark.scranton@gmail.com wrote: > 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. 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
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> informix-list@iiug.org Sent by: cc informix-list-bou nces@iiug.org 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 Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
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.iiug.org/conf for more information. -----Original Message----- From: mark.scranton@gmail.com [mailto:mark.scranton@gmail.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
Art S. Kagel wrote: > mark.scranton@gmail.com wrote: > > 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. > > 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 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 crap 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