Introduction to Database Analyzer Charts
The Database Analyzer is SAP MaxDB's main tool for examining the state and performance of databases. The Database Aanalyzer writes multiple log files in preset intervals.
Based on this data which is stored as CSV-formatted files, the Analyzer builds reports on the state of the database. So far the database admistrator had no influence on the SAP MaxDB Database Analyzer reports. This changes completely with Database Analyzer Charts: The Database Analyzer Charts together with the predefined Metric Templates provide a new functionality, which enables the administrator for the first time to visualize the collected performance data of the database. Now it is possible to create arbitrary reports and graphical evaluations based on any combination of data in the logging files.
- Analyze database data graphically. See Working with Database Analyzer Charts for details.
- Choose freely which metrics shall be displayed in the graph. See Table and Column List in Detail for details.
- Define a time span for the graph. See Functionality of the Diagnosis Chart View for details.
- Navigate between recently opened charts and time spans. See Navigating between recently opened charts/time intervals for details.
- Benefit from predefined anlyses that open automatically with many Database Analyzer files. See Metric Templates for details.
- Adjust predefined anlyses by changing the settings according to your needs. See Working with Metric Templates for details.
- Apply an analysis that you have done for a table upon another table (even from another database). See Applying a predefined Analysis to another Database for details.
- Save your analysis as a template so that you can reuse it. See Retaining an Analysis and Reproducing an Analysis for details.
- Share your templates with colleagues. See Specifying the Location for Remote Metric Templates for details.
- Combine data from multiple tables in one graph. See Combining two CSV Files to a merged Product for details.
- Hide and display individual columns in the table. See Table and Column List in Detail for details.
- Rearrange the column order within the table. See Rearranging the Column Order for details.
- Add virtual metrics with derived values. See Virtual Columns for details.
- Define threshold values that issue visual warnings if they are surpassed or undershot. See Issuing Warnings for Values for details.