Conference Paper

Evaluation of Adaptive Computing Concepts for Classical ERP Systems and Enterprise Services

Technische Univ. Munchen
DOI: 10.1109/CEC-EEE.2006.45 Conference: E-Commerce Technology, 2006. The 8th IEEE International Conference on and Enterprise Computing, E-Commerce, and E-Services, The 3rd IEEE International Conference on
Source: DBLP

ABSTRACT

To ensure the operability and reliability of large scale enterprise resource planning systems (ERP), a peak-load oriented hardware sizing is often used. Better utilization can be achieved by employing an adaptive infrastructure based on smaller computational units in combination with an intelligent allocation management. The SAP University Competence Center (German SAP HCC) at the Technische Universitat Munchen provides support for 55 ERP training systems. The evaluation of the historical load data revealed that many applications exhibit cyclical resource consumption. In this paper we show the extraction of load patterns and present self-organizing controlling concepts in the context of the SAP HCC

Download full-text

Full-text

Available from: Helmut Krcmar, Jan 28, 2016
    • "The evaluation of historical workload data reveals that cyclical resource consumption is a regular phenomenon in many database server environments. For example, in [2] authors show the extraction and identification of load patterns, which can be used for optimization of static or dynamic allocation. Figure 1. "
    [Show abstract] [Hide abstract]
    ABSTRACT: This paper analyzes the relationship between the system load/throughput and the query response time in a real Online transaction processing (OLTP) system environment. Although OLTP systems are characterized by short transactions, which normally entail high availability and consistent short response times, the need for operational reporting may jeopardize these objectives. We suggest a new approach to performance prediction for concurrent database workloads, based on the system state vector which consists of 36 attributes. There is no bias to the importance of certain attributes, but the machine learning methods are used to determine which attributes better describe the behavior of the particular database server and how to model that system. During the learning phase, the system's profile is created using multiple reference queries, which are selected to represent frequent business processes. The possibility of the accurate response time prediction may be a foundation for automated decision-making for database (DB) query scheduling. Possible applications of the proposed method include adaptive resource allocation, quality of service (QoS) management or real-time dynamic query scheduling (e.g. estimation of the optimal moment for a complex query execution).
    No preview · Article · Jan 2015 · Advances in Electrical and Computer Engineering
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: To ensure the operability and reliability of large scale Enterprise Resource Planning Systems (ERP) and enterprise services, a peak-load oriented hardware sizing is often used, which results in low average utilization. The evaluation of historical load data revealed that many applications show cyclical resource consumption. The identification of load patterns can be used for static as well as dynamic allocation optimization. In this paper we show the extraction of load patterns and present self-organizing service alloca- tion concepts. This practical evaluation of theoretical adaptive computing concepts is of particu- lar importance for the configuration of emerging service oriented architectures (SOA).
    Full-text · Conference Paper · Jan 2007
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: Advances in server, network, and storage virtualization are enabling the creation of resource pools of servers that permit multiple application workloads to share each server in the pool. This paper proposes and evaluates aspects of a capacity management process for automating the efficient use of such pools when hosting large numbers of services. We use a trace based approach to capacity management that relies on i) a definition for required capacity, ii) the characterization of workload demand patterns, iii) the generation of synthetic workloads that predict future demands based on the patterns, and iv) a workload placement recommendation service. A case study with 6 months of data representing the resource usage of 139 workloads in an enterprise data center demonstrates the effectiveness of the proposed capacity management process. Our results show that when consolidating to 8 processor systems, we predicted future per-server required capacity to within one processor 95% of the time. The approach enabled a 35% reduction in processor usage as compared to today's current best practice for workload placement.
    Full-text · Conference Paper · Aug 2007
Show more