BaseLines

A BaseLine is a collection of all SELECT SQL statements that represent the typical traffic your application creates and executes against a database.

We recommend having two BaseLines for your application.

• Production BaseLine: This BaseLine represents real-life production traffic. It helps monitor the rhythm of your production workload during different conditions. Additionally, it serves as a true reference of current traffic patterns, which can be compared with new releases to identify any changes or anomalies.
• Test BaseLine: This BaseLine is generated from a test environment, either through automated or manual testing processes. It is used for code-coverage analysis, highlighting any untested SQL patterns found only in your production BaseLine. Improving test coverage with this information helps reduce unexpected outcomes.

When creating a new BaseLine you define the primary characteristics and the BaseLine will have a status of No Queries. You add the queries for the BaseLine using one of the approved file formats which will product a status of Unprocessed. When you Validate, the status of the BaseLine will be Ready. A BaseLine must be in this state before this can be used for any experiments.