MSBI (SSIS/SSRS/SSAS) Online Training

Monday, September 13, 2010

Capacity Planning for the DW/BI Environment


Hi All-
Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process. These two functions, BI reporting and ETL, grow in volume and frequency as a data warehouse grows. Additionally, database administrator (DBA) tasks, such as backups and table reorganizations can cause additional data warehouse bottlenecks because ETL, BI reporting and DBA tasks contend for the same resources.
On top of that even we can maintain capacity of DW/BI environment by analyzing the below analytical approaches.
how many customers will be in the warehouse?,
at what rate will the customers grow?,
how many transactions will be in the warehouse?,
at what rate will the transactions grow?,
what other data will be in the warehouse?,
at what rate will the other data grow?,
what is the proper level of granularity for data in the warehouse?,
can the level of granularity be changed if needed?,
what amount of history is needed in the warehouse?,
will the user decide to add more history than anticipated?, and so forth.
See the below links for more info.
http://www.inmoncif.com/view/33
http://www.dmforum.org/portal/library/capacityplanningforthedwInmon.pdf
~Ravindra

No comments: