What is the “power” metric (QppD)?
The power metric is based on a geometric mean of the 17 TPC-D queries, the insert test and the delete test. It measures the ability of the system to give a single user the best possible response time by harnessing all available resources. The inverse of the computed geometric mean is converted to hours from seconds and scaled by the database volume (SF) to obtain QppD. Therefore, the complete formulation is: 1 * 3600 QppD = ——————— * SF GM (Q1..Q17,UF1,UF2) where GM is the geometric mean.
