DATABASE CAPACITY ESTIMATION FOR DATABASE SIZING

摘要

A method and system for sizing databases. Multiple patterns of historical capacity usage by multiple databases are identified. The multiple patterns are statistically significant for multiple characteristics pertaining to utilization of multiple historic databases. The capacity usage is memory usage or central processing unit (CPU) usage. A weighted value of capacity usage is computed for each pattern as an average value of historical capacity usage for each pattern weighted by a function of a fraction of the multiple databases used for each pattern. A total value of capacity usage is computed as a sum of the weighted values of capacity usage. The computed total value of capacity usage is stored. A current database is sized, utilizing the computed total value of capacity usage. The database sizing may be based on query complexity in dependence on rates of occurrence of queries to the historic databases and to the current database.

主权项

1. A method for sizing databases, the method comprising:
receiving, by one or more processors, an input value of each characteristic of multiple characteristics pertaining to utilization of multiple databases in a computer system; identifying, by the one or more processors, multiple patterns of historical capacity usage by the multiple databases, wherein the multiple patterns are statistically significant for the multiple characteristics and encompass the input values, and wherein the capacity usage is memory usage or central processing unit (CPU) usage; computing, for each pattern, by the one or more processors, a weighted value of capacity usage as an average value of historical capacity usage for each pattern weighted by a function of a fraction of the multiple databases used for each pattern; computing, by the one or more processors, a total value of capacity usage as a sum of the weighted values of capacity usage; and sizing, by the one or more processors, one or more current databases via utilization of the computed total value of capacity usage.