Method R Discussion Group

Method R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle.

Discuss Method R products, techniques, and events.

Ask new questions or post your own responses.

Basic Matrixs for forecasting analysis exercise.

I am quite new to the performance forcasting thing. Please let me know what are the common basic matrics we can keep into our consideration while forcasting for the performance.
Suraj Sharma Send private email
Sunday, May 13, 2007
 
 
Suraj,

I believe there's one and only one metric that a performance manager should be monitoring and managing: the response time of end-user business tasks. If you know the exact duration--from the end-user's perspective--of all your business tasks, AND you have the ability to drill into any of those durations--to know exactly WHY that task took that long--then you have everything you need to solve performance problems that have happened in the past.

To /predict/ performance of something in the future, you need the same information (response times and their detailed decompositions), /plus/ you need some information about the capacity of your system. I used to talk in very complicated terms about queueing models, but a couple years ago I figured out that it doesn't need to be that difficult. You just need to make sure that you keep utilization statistics for all your resources beneath their critical knee values (called "rho-star" in the book "Optimizing Oracle Performance that Jeff Holt and I wrote). Below those utilizations, performance is easy to predict with simple linear models.
Cary Millsap Send private email
Monday, May 14, 2007
 
 
Hi Cary,

Thanks a lot for your time and making me understand this complicated thing in a very simple term. I really appriciate the same.
Suraj Sharma Send private email
Tuesday, May 15, 2007
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Discussion Groups Main Page

Powered by FogBugz