Demos and Applications Session
Storage Class Memory, Database Tuning
Database system tuning activity aims at maximizing system resource utilization in order to provide performance gains for database applications. On the other hand, it is remarkable the popularization of a new media type, called Storage Class Memory (SCM). This type of media has emerged with the purpose of decreasing the latency found in the access time of HDDs, thus increasing the throughput which processors can consume more data. Nonetheless, DBMSs and performance tuning tools are not prepared yet to deal with the various underlying characteristics of these new media. In this paper, we propose a tool SCM-BT2, which makes possible for DBAs to undertake performance monitoring related to the use of different buffer management policies, making it possible to compare the performance gains obtained in the context of SCM.
Júlio A. Tavares, José de Aguiar Moraes Filho, Angelo Brayner, Saulo Medeiros