FW: Disk capacity planning

[Cary Millsap]

I don’t think this one made it through on my first attempt.   Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7–10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: Cary Millsap [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Subject: RE: Disk capacity planning   Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system’s peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you’ll really, truly need.   The way I’d recommend structuring your project is to evaluate the following:   -          How many bytes will you need to store your data? How many disks is that? Call the answer B. -          How many disks will you need to meet your IOps requirements? Call the answer P. -          How many disks will you need to meet your availability requirements? Call the answer A. -          (Consider other attributes as necessary, like perhaps I/O throughput requirements…)   Roughly speaking, the number of disks you’ll need to buy is max(B, P, A, …). It’s more complicated than that because you’ll need to segment your total drive set into sensibly-sized arrays, you’ll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system.   Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7–10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Subject: Disk capacity planning   Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel