Show TOC

Multiple Opportunities and Ways for Analyzing Database Analyzer DataLocate this document in the navigation structure

Double click a CSV file to see the effect of the Default Metric Template which is part of the Database Studio delivery. Not every CSV file has a default Metric Template. But if there is an assigned Default Metric Template, double clicking on a CSV file will show the metrics which were defined in the Default Metric Template.

It is possible to change the properties of a Metric Template and save it as your own Default Metric Template.

You can adjust the following properties:

  • Colors - Specify another color for displaying the metric.
  • Choose further metrics to be displayed in the chart view.
  • De-select metrics which are selected per default.
  • Define virtual metrics built on derived values from other columns.
  • Make columns visible in the graph.
  • Hide visible columns.
  • Define additional virtual columns.

You can save the modified Metric Template under a meaningful name

  • as your own local Metric Template, or
  • in a public folder in order to share it with colleagues.

You can also combine a metric with multiple other metrics and save this bundle as a new Metric Template.

All Metric Templates which are saved as Named Metric Templates are reusable. They are the outcome of established and approved analyses.

You might want to store all the relevant Metric Templates for your specific analyses you have done so far in a folder with a meaningful name.

Having such a folder with several Metric Templates helps you:

  • To rerun the analyses you have done so far.
  • To apply the expert knowledge stored within a Metric Templates to another database.
  • To compare a behaviour at one point in time with another point in time.