Capacity Planning and benefits
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.
Capacity planning is a very important activity that avoids unexpected performance degradation and space issues overtime. Adlab provides monthly capacity planning reports, detailing and suggesting the steps to improve systems health.