Who Does Data Warehouse Capacity Planning?
But the heart of the matter is how much storage and how many and what kind of processors should be used for the data warehouse. Key Factors The two key factors the capacity planner looks at are the amount of data there will be and the workload that will be run against the data warehouse. Unfortunately, both of these factors in the data warehouse DSS environment are very difficult to ascertain. The Analytical Approach The first approach to capacity planning is the analytical approach. The analytical approach is one where the capacity planner attempts to calculate and/or predict capacity needs before the equipment is purchased.
