Database Sizing and Capacity Planning

Database sizing is designed to give you estimates of the database growth and to assist in planning the disk requirements.

There are many factors to consider when estimating the amount of disk space that will be required for Sterling B2B Integrator. As a result, trying to consider all growth factors is impractical because the user may not know the answers to many questions that are required to do a detailed forecast. Over the years the cost of disks has dramatically decreased, and the capacity and speed of disks has increased. The method of how information system managers order disk capacity has also changed, from purchasing disk arrays that are dedicated to a particular database server and project, to the concept of SANS (Storage Area Networks).

Sterling B2B Integrator provides a methodology to estimate your initial disk requirements. Consider the confidence that you have in your data estimates when making the final purchase decision and adjust accordingly. After the initial purchase and production deployment, disk growth should be tracked for future purchase forecasts.

You should track your actual database storage usage and the number of database records regularly. Correlating these two metrics enabled you to plan your future disk requirements. Moreover, determining the average amount of space used for each order line or shipment line, enables you to accurately predict your future growth requirements.