A General-Purpose OLTP Sizing Tool

To illustrate the principles outlined in this chapter, I am including a description of the development of a general-purpose OLTP sizing tool used within Sun to assist systems engineers and sales representatives with OLTP database server sizing. The material that follows is drawn from a paper titled “Developing a General-Purpose OLTP Sizing Tool” (Allan Packer and Brian Wong) delivered at the Computer Measurement Group (CMG) International Conference in Orlando, Florida, in December 2000. The paper is used with the permission of the CMG.

The rationale behind developing an OTLP server sizing tool was simple: sizing is a difficult task, as we have seen, and much useful data gathered within the Sun engineering organization ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.