FW: Disk capacity planning

I don’t think this one made it through on my first attempt.

 

-----Original Message-----
From: Cary Millsap [mailto:cary.millsap@hotsos.com]
Sent: Tuesday, January 13, 2004 5:54 PM
To: 'ORACLE-L@fatcity.com'
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.

 

-----Original Message-----
From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On Behalf Of Rhojel_Echano@sgs.com
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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).