A CLOSED QUEUING NETWORK MODEL TO EVALUATE THE IMPACT OF RECOVERY OPERATIONS ON THE PERFORMANCE OF DATABASE SERVERS

As database servers proliferate in modern information systems architec tures in organizations, the issue of protecting and recovering the dat abases becomes of utmost importance. By developing an analytical model based on a closed network of queues, this paper analyses how differen t database recovery mechanisms impact on the normal transaction proces sing. Such a model enables one to capture intricate effects that are p eculiar to complex, tightly coupled, multi-component systems, such as database recovery systems, and can be used to facilitate the design an d the tuning of database recovery managers. The proposed model provide s important performance measures in terms of average transaction proce ssing time and overall systems throughput. Numerical experiments using actual recovery methods demonstrate the effectiveness of the modellin g approach.