A METHOD AND A SYSTEM FOR CAPACITY PLANNING

摘要

The present invention relates to a capacity planning method for Always On Availability Group, AG, cluster renewal. The method comprises selecting a source AG cluster to be replaced with a target AG cluster, selecting at least one performance monitor and monitoring performance of instances and databases of the source AG cluster with the at least one performance monitor to obtain time series. Further, trends of the time series are defined and at least one benchmark value is obtained for source and target nodes and calculating at least one benchmark ratio. Said time series are adjusted based on the defined trends and the at least one benchmark ratio. A logical grouping of instances and databases of the source AG cluster is constituted, and workloads of the logical groups are calculated for each node of the source AG cluster on basis of the adjusted time series. A required capacity of the target AG cluster nodes is predicted on basis of calculated workloads. Finally, the required capacity of the target AG cluster nodes is compared to at least one target node capacity to verify, whether the target node has sufficient capacity.