The Database Analyzer User Interface - an Overview

This chapter describes the main components of the Database Analyzer Charts window. In addition to the standard elements of the Database Analyzer (like the menu bar and button toolbar) the graphical user interface is comprised of four parts:

1. The Explorer View

   The Explorer view provides the access to your database server and databases. From here you can log in to a database and open the Database Analyzer files.

2. The Table/Editor View

   The Database Analyzer files you have opened are shown in this part of the window. The files are written in CSV format and are displayed as tables. You may open as many files as necessary for analysis.

3. The Column List

   The column list catalogues all columns of the active Database Analyzer file. From here you can choose:

   • Which columns are shown in the table view.
   • Which columns are the metrics to be shown in the diagnosis chart.

4. The Diagnosis Chart

   This is the chart view. Every chosen column represents a metric which is displayed as graph here in this chart view. That means: the columns that are selected in the column list are automatically drawn as a line chart.

   The x-axis is the timeline axis and the y-axis shows the value range of the metric. Both adapt themselves to the chosen time interval and the value range of the chosen metric.

In the following we will explain the usage of Database Analyzer Charts in detail and will explain the individual elements and options that are provided for analysis of database performance.