At 11:04 AM 1/18/2004, Thomas Jeff wrote:
Tim,
Thanks for the
reply. We are thinking more along the lines of metrics
pertaining
to identifying the required efficiency of the outsourced ETL task, e.g.
time, resource
utilization,throughput, etc, in essence some desired baseline resource
profile.
We are new to
writing up RFPs at this level of granularity with respect to services, so
if this all rather unreasonable, in yours (or anyone's) opinion, I'd like
to know.
So long as you have the ability to reasonably estimate things like LIO's
for a task, I don't see this as at all unreasonable. I'd certainly
rather have a quantifiable performance metric to hit than deal with the
vagueness of "fast enough". On the other hand, if you
don't have a good basis on which to estimate the number of LIO's this ETL
process would take if it is well-written, you may be setting an
unreasonably high or unreasonably low bar.
Since you're writing this RFP at a more granular level than you're
accustomed to, I would suggest starting with metrics that are easier to
understand and predict but tend to be less accurate. Wall clock
time is readily understood, easy to verify, and reasonably easy to
estimate. If I have other ETL processes that can load 10 million
rows per hour from a file into a particular table structure and this ETL
process will have a similar amount of data, a similar validation process,
and a similar table structure, you can probably infer that 10 million
rows per hour is a reasonable metric. If there are other things
running at the same time, you'd have to qualify the requirement with the
amount of CPU, RAM, I/O, etc that will be available to this new ETL
process.
Justin Cave
It's
not just a matter of defining that the deliverables are to be completed
during X number of
days for $ cost, but we are thinking that we need to identify some
metrics that would help
us to specify some acceptable performance criteria, against which we
would monitor when
performing some form of acceptance testing. It does us
no good if the contracted ETL
task capitalizes the box (like the runaway PL/SQL program mentioned by
Ryan) and takes
3 days to complete.
- -----Original Message-----
- From: Tim Gorman
[mailto:tim@sagelogix.com]
- Sent: Friday, January 16, 2004 10:54 PM
- To: Multiple recipients of list ORACLE-L
- Subject: Re: SLA/metrics for RFP for programming
services
- How about specific deliverables within a specific
period of time for a total amount not-to-exceed? Can’t think of any
other metrics that matter...
- on 1/16/04 2:19 PM, Thomas Jeff at jeff.thomas@thomson.net
wrote:
- If you were to write up a RFP for
programming services, what kind, if any,
metrics
- would you include to provide some
measurements by which performance of the
contract
- can be assessed? The
tasks will typically be writing up ETL runs for our
DW.
- CPU, LIO, wait events,
etc?
- Thanks!
- -
-------------------------------------------
- Jeffery D Thomas
- DBA
- Thomson Information Services
- Thomson, Inc.
- Email: jeff.thomas@thomson.net
- Indy DBA Master Documentation available at:
- http://gkmqp.tce.com/tis_dba <http://gkmqp.tce.com/tis_dba>
- --------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Justin Cave
INET: jcave_at_cableone.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Jan 19 2004 - 08:34:27 CST
