Posted by Martyn R Jones on September 19, 2001 at 04:25:11:

In Reply to: Datawarehouse performance issues posted by Patterson on September 18, 2001 at 10:34:51:

Hello,

I would say from experience that the critical areas of concern in Service Levels for the DW are in:

Performance
Availability
Reliability

Performance - Produce a set of queries of varying levels of complexity, from real simple (type 1 query) through real complex query (type 5 query), you might like to have more or less levels - measure the time taken to run these queries and the resources needed to run these queries (number of rows retrieved, sorted merged etc). Create query profiles by which you can agree on acceptable query response times for query types - you can always buy more hardware and go through the benchmarking exercize again if respoonse times are not acceptable.

Availability - like service level agreements for example, the trains, planes and buses running on time - it must be tied to realizable availability and time requirements (source system availability, extraction, transformation, loading, reporting etc.), and not just a wish list, also, make sure your systems, including your network can scale with increased demand

Reliability - Again this is tied to a SLA, you may promise to provide 24x7x52 availability, but this is expensive to achieve normally - again its a balancing act between what you can afford to provide and what the users think they should get - set expectations before you really get underway

There is so much in this area that one could talk all day about it - and I often do, for a fee that is.

Regards,

Martyn R Jones
Consulting

• KM

---

Follow Ups:

---

Click Here to Post Follow Up in New Forums

    Knowledge Management Think Tank (New)

  

 Subject: 

Message: