pcp
[Top] [All Lists]

DMBS Add-ons for Performance Co-Pilot

To: Alan Hoyt <ahoyt@xxxxxxxxxxxxx>, Mark Boyd <mark.boyd@xxxxxxxxxxxxx>, Chris Howland <chris.howland@xxxxxxxxxxxxx>
Subject: DMBS Add-ons for Performance Co-Pilot
From: kenmcd@xxxxxxxxxxxxxxxxx
Date: Sat, 26 Jul 2003 15:33:31 +1000 (EST)
Cc: PCP <pcp@xxxxxxxxxxx>, "'Said Maafala'" <orapmda@xxxxxxxxx>
In-reply-to: <BEEBIMCONFJDIAHJNDPJEEGIDKAA.chris.howland@moser-inc.com>
Reply-to: kenmcd@xxxxxxxxxxxxxxxxx
Sender: pcp-bounce@xxxxxxxxxxx
My apologies for the tardiness in responding here ... we've had several
overlapping issues that have been demanding the attention of our open
source engineers and our legal team.

I would like to make the following proposal:

1. We bundle all of the source for the dbms PMDAs into one package
   to be known as "DBMS Add-ons for Performance Co-Pilot".  This would
   include PMDA implementations for (old) verions of Oracle, Sybase,
   Informix.

   The name issue is important, because Performance Co-Pilot is a
   trademark of SGI, and we have to take certain actions to protect
   that trademark, and one of them is to ensure that there is no
   confusion between the _real_ PCP, and something that "works with PCP".
   Similarly adding Oracle, Informix and Sybase to the title will only
   risk incuring the wrath of a different bunch of lawyers.

2. We negotiate and select someone to act as the gatekeeper for this
   source.

   SGI is not planning to maintain any down-stream responsibility for
   this code, so in particular we do not want to deal with bug reports
   or patches.

   We are willing to add a pointer to it from the PCP project
   page on oss.sgi.com.

3. We will make the source in 1. available to the person(s) selected in
   2. under the standard GPL.

   Thereafter, you can do with it as you please, subject to the terms and
   conditions of the GPL.

Is this acceptable?

Could I ask for volunteers as per 2. above?

On Mon, 3 Mar 2003, Alan Hoyt wrote:

>  >Also from the http://oss.sgi.com/projects/pcp/contribute.html page:
>  >
>  >Agents for Oracle, Informix and Sybase (we have these for IRIX, but
>  >need someone with relevant DBMS expertise who might be willing
>  >to make them operational for Linux and help keep them working
> 
> Two Issues:
> 
> 1) I have had some detailed discussions with Mark Boyd about per session 
> metrics and name space management on large servers running multiple 
> Oracle instances - there seems to be a diverging metrics acquisition 
> philosophy emerging.
> 
> 2) We need to get the Oracle and Sybase pmdas into PCP release 2.4.
> 
> Having access to the existing Oracle/Sybase pmda source code could help 
> elucidate design tradeoff decisions that were made in the older releases 
> and help expedite our efforts.
> 
> What we are proposing:
> 
> If SGI provides:
> ? Open Source versions of the existing Oracle and Sybase pmdas
> ? Any related Oracle/Sybase QA scripts (whenever the opportunity arises).
> 
> We will provide:
> ? Clean up existing source code - merge pmda code and resolve metric 
> acquisition philosophies between pmdas (adding support for Oracle 8.1.7 
> and 9.2 - i.e. a substantial update).
> ? Clean up non portable source dependencies (i.e. IRIX, Linux IA32, 
> Solaris)
> ? Provide RPM and PKG build scripts
> ? Provide on-going maintenance and gatekeeper functions for Oracle and 
> Sybase pmdas.
> 
> Note: Our pmda should support Oracle 9.2 on Linux IA64 (which is 
> currently in beta) but this is not currently a priority.
> 
> As a result, the wider PCP community would benefit from having updated 
> Oracle and Sybase pmdas - this would definitely help improve the value 
> added prospect of PCP.
> 
> 
> - Alan -
> 
> 
> 
> 

On Mon, 12 May 2003, Mark Boyd wrote:

> Ken -
> 
> That's interesting news.  I would be willing to "volunteer" to be the
> maintainer of the code, as I am nearly finished with my own Oracle PMDA
> as I type this.  I've been working on it, albeit slowly, for a few
> months now and I would be very interested to see how my agent compares
> with the one SGI wrote.  Let me know how can I help.  Thanks!
> 
> Mark Boyd
> Senior Consultant
> Moser Consulting, Inc.
> Office: 317.596.8022
> Mobile: 317.694.8105
> Fax: 317.596.9055
> email: mboyd@xxxxxxxxxxxxx
> 
> 
> -----Original Message-----
> From: pcp-bounce@xxxxxxxxxxx [mailto:pcp-bounce@xxxxxxxxxxx] On Behalf
> Of kenmcd@xxxxxxxxxxxxxxxxx
> Sent: Monday, May 12, 2003 6:11 PM
> To: Said Maafala
> Cc: pcp@xxxxxxxxxxx
> Subject: Re: Oracle Agent?
> 
> 
> On Tue, 14 Jan 2003, Said Maafala wrote:
> 
> > 
> > Hello -
> > 
> > This is not right place for this question, I know this, but spoke to 
> > salesperson at SGI to buy Oracle Agent for PCP and told me they did 
> > not have on price list?  Is there IRIX Oracle Agent for PCP exist? Is 
> > Open Source now?  Please can you help me get Oracle Agent?  If exist, 
> > but not for sale, can put in Open Source?  I know this Oracle has no 
> > new version for IRIX.  Does mean cannot buy Agent no longer? Please 
> > help!
> 
> There once was an Oracle agent for PCP.  This was a proprietary add-on
> in the days before the open source release of any of PCP.  This product
> no longer exists (so the salesperson is correct).
> 
> There are plans underway to turn over this source code to the community
> once we've negotatiated the transition.  This has been signed-off by the
> Open Source Review Board within SGI, and the ball is in my court to
> complete the transitional arrangements with an external volunteer who
> will become the maintainer for this code.
> 
> 
> 
> 
> 
> 

On Mon, 16 Jun 2003, Chris Howland wrote:

> I am in the process of attempting a Sybase agent for pcp.
> 
> I think it has the potential to be a great tool.
> I could use any comments,questions, suggestions,
> from anyone who may have tried this, or something similar.
> 
> Are there any resources available from the previously 
> commercial version of this? code snippets, documentation,
> list of metrics, etc?
> 
> Is the proprietary version of the Sybase agent going to
> be turned over to the open source community any time soon?
> 
> 
> Thanks.
> 
>       Chris
> 
> Chris Howland         chris.howland@xxxxxxxxxxxxx
> 
> 
> 

On Fri, 27 Jun 2003, Chris Howland wrote:

> Well, after some investigation, I discovered the manual pages
> for the original Sybase PMDA. I didn't see a complete list
> of metrics supported, though.
> 
> Looks like system 10 is the most recent version supported?
> 
> Mark, is it possible to get this Sybase agent open sourced?
> 
> I would be willing to take anything you have, and clean it up,
> get it working on Linux, and get it working with newer versions
> of Sybase ASE.
> 
> If that isn't possible, can I at least get an output of "pminfo -fT sybase"
> ??
> 
> 
> Thanks!
>       Chris
> 
> 
> Chris Howland
> 
> chris.howland@xxxxxxxxxxxxx
> 
> 
> 




<Prev in Thread] Current Thread [Next in Thread>