Rules Of Thumb (performance)This is a featured page

Amdahl's Law - (Gene Ahmdahl)
  1. The performance enhancement possible with a given improvement is limited by the fraction of the execution time that the improved feature is used
Optimizing Oracle Performance - (Cary Millsap)
  1. response time = service time + wait time
  2. Work first to reduce the biggest response time component of a business' most important user action
  3. Reliable problem diagnosis cannot proceed unless the data collection phase produces response time data for exactly the righttimescope and exactly the rightactionscope
  4. Execute the candidate optimization activity that will have the greatest net payoff to the business. If even the best net payoff activity produces insufficient net payoff then suspend your performance activities until something changes.
  5. Practice makes permanent. Onlyperfectpractice makes perfect
  6. You can't extrapolate detail from an aggregate
  7. You can't tell how long something took by counting how many times it happened
  8. Response time is the elapsed time between the end of an inquiry or demand on a computer system and the beginning of a response
  9. Compartmentalized organisational units tend to optimize in isolation from other organizational units, resulting in locally optimized components. A system consisting of locally optimized components is not necessarily itself an optimized system
  10. There's nothing worse than working hard on the wrong thing, expecting improvement from it, then ending with nothing
  11. Many systems' workloads consist of more than 50% waste
  12. Almost every performance problem is caused byexcessive demandfor one or more resources
  13. Is the apparent requirement to use so much of this resource actually alegitimaterequirement?
  14. A capacity upgrade is going to helpsomepart of the system's workload, but the key issue is whether it will help a business priority
  15. Find the source text (SQL or PLSQL) of the cursor that contributes the most to the duration of the component



consultium
consultium 		Latest page update: made by consultium , Oct 9 2009, 9:02 AM EDT (about this update About This Update consultium Edited by consultium

303 words added

view changes
- complete history)
Keyword tags: None
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.