The selection of tunable DBMS resources using the incremental/decremental relationship

Abstract

The DBMS performance might change by allocating resources and by performing a specific kind of workload. Database administrators should be able to identify relative resources that can change DBMS performance in order to effectively manage database systems. This paper aims to identify the relative resources that can affect the DBMS performance depending on the different kinds of workload. The relative resource is identified by the incremental or the decremental relationship between the performance indicator and the resource. The relationship is determined by the Pearson's correlation coefficient with the t-test. We identify the relative resources that have an impact on the DBMS performance under TPC-C and TPC-W benchmarks using our proposed method. As a result, the data buffer and the shared memory could affect the DBMS performance in TPC-C, and only the data buffer in TPC-W. In order to verify our works, we measure the maximum load that can be executed in the individual system for TPC-C and TPC-W. © Springer-Verlag Berlin Heidelberg 2007.