End-to-End Performance Monitoring of Databases in Distributed Environments

: This demonstration features the IBM DB2 Performance Expert for Linux, Unix and Windows, a high-end database monitoring tool that is capable of end-to-end monitoring in distributed environments. Performance Expert closely tracks the execution of database workload, from the point when the workload is issued in a database application, to its actual execution by the database server. This enables us to break down the response time as experienced by the user into time spent waiting for connections, within database drivers, the network, and finally, within the database server. From a data management point-of-view, the main challenge here is the handling of large amounts of performance data. We show how this challenge is met by continuous aggregation, and the definition of so-called workload cluster groups, which organize and narrow down the data of interest. 1 Motivation Whether configuring, optimizing, or administrating databases and database applications, it is vital to maintain statis...

• Type: Conference
• Year: 2009
• Where: BTW
• Authors: Stefanie Scherzinger, H. Karn, T. Steinbach
• Keywords: BTW 2009, Database, Database Application, Database Server