Linear Growth Linear growth includes a steady increase of a specific amount during each time period. For example, growing 200GB per year in terms of database size, or increasing by 10 transactions per minute annually in terms of database usage. The rough estimate of linear growth is the quantity of growth multiplied by the number of time periods. This method can be expressed with the following equation: Future Usage = Current Usage + (Growth Amount × Number of Periods). For instance, if a database currently processes 40 transactions per minute and increases by 10 transactions per minute annually, we can calculate the database usage over the next three years by substituting these values into the equation: Usage within the next 3 years = 40 + (10 × 3) Usage within the next 3 years = 70 transactions per minute.
Geometric Growth Geometric growth, also known as compound growth, is represented by a fixed percentage, factor, or ratio during each time period, such as a 2% monthly data growth. To calculate future needs using geometric growth, use the following formula: Future Usage = Current Usage × (1 + Growth Rate) ^ Number of Periods. When using this equation, ensure that the growth rate is expressed in decimal form. For example, if the current database size is 600GB and the growth rate is 2% per month, we can calculate the database size after three years by substituting these values into the following equation: Database Size in 3 Years = 600 × (1 + 0.02)³⁶ Database Size in 3 Years = 600 × (1.02)³⁶ Database Size in 3 Years = 600 × 2.04 Database Size in 3 Years = 1224GB
Approach to Planning Server Capacity The choice of server design approach depends on various factors, such as the amount of available financial resources, the status of the database application under consideration, and the amount of historical performance data available.
Original article from Anhui Server Data Recovery Center: http://www.ahserver.com/plus/view-62-1.html