5 research outputs found

    Managing the Performance Impact of Administrative Utilities

    Full text link

    Discovering Indicators for Congestion in DBMSs

    Get PDF
    Abstract-In today's data server environments, multiple types of workloads can be present in a system simultaneously. Workloads may have different levels of business importance and unique performance goals. An autonomic workload management system controls the flow of the workloads to help the database management system (DBMS) meet the performance goals. A task of the autonomic workload management system is to prevent congestion in the DBMS, which can result in severe degradation in overall system performance. Autonomic workload management should detect that a system is becoming congested and then act to restore normal system operation. In this paper, we describe an approach to identify a set of database monitor metrics that can serve as indicators for potential congestion in a specific scenario. We present experiments to illustrate two cases of congestion in a DB2 ® DBMS and use our approach to derive the indicators

    A control theory foundation for self-managing computing systems

    Full text link

    Managing the Performance Impact of Administrative Utilities

    No full text
    LIMITED DISTRIBUTION NOTICE: This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has been issued as a Researc
    corecore