« Chips with everything | Main | Storage is cheap or should you purge? »

Performance of high volume systems

In my earlier post, chips with everything, I discussed the issue of what is a processor.  This leads inexorably to the topic of how to get the best performance out of the servers that you have bought.  While practice makes perfect it is also worth considering some models to help you work out the feasibility of what you are proposing.  Oracle 10g has a performance tuning guide in the documentation set and includes sections on:
Designing and developing for performance
Performance Improvement Methods
and
I/O Configuration and Design

There are also other helpful sites out there in the Oracle community.  Of particular interest to me due to my mathematics background is the queueing theory model expounded here: http://resources.orapub.com/forecast_main.asp
and there are many others.  My recommendation is that if you know you need to have a performant system, use these ideas to help you, your DBAs and your developers have performance in their minds whenever they are building or writing functionality.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)