"About Capacity planning in Data Warehouse"

[aliamerica]

I am currently doing a research on Capacity planning in Data Warehouse.
I would like to know about some real world examples Capacity planning in Data Warehouse implementation.

Q.How capacity planning helps in the improvement of the Data warehouse?

It would be a great help if you could provide me with some case study about Capacity planning in Data warehousing.

Q.When is the capacity planning done in data Warehouse implementation ?

Q.How do we compute Capacity?

Q.Remedies to Capacity problems?

Q.Processor Capacity?

Q.What portions of the DW will be managed on Disk Storage and Alternative Storage?

I would really appreciate if you could please help me in this regard.

thanks a lot

 

[kishleo]

oops too many questions....
go through this article from inmon...

http://www.billinmon.com/library/whiteprs/earlywp/ttcapac.pdf

ô¿ô Kishore

 

[kingofthehill]

Capacity Planning can improve the performance of Data Warehouse by:
1) Ensure that adequate resource i.e CPU, MEMORY and DISK SPACE is available for the application.The plan usually includes current/immediate and/or future usage and growth.
2. Capacity Planning usually starts during planning phase where the size of data feeds and application requirements to transform these data are considered. From there, the planning is ongoing and current resource usage are analyzed and kept for trending.
3. I'v seen IBM or hardware vendor TPC or Warehouse Benchmark Results and maybe a good start to compute capacity. These usually includes #of transactions and machine type results.
4. One thing to remedy capacity is to ensure that POC or Proof of Cencept is built and measured using close to production data.
5. Again use vendor's TPC or warehouse benchmark as start. Add padding factor of 25-30%, better to be over than under capacity.
6. Decide on the retention period as per business requirement. Ensure that all of the required data are stored online. The disk cost is relatively low and cost of archiving and retrieval from tapes usually is offset by the benefits of keeping them online.