The main tasks for using QPTune for application or query tuning are:
Start QPTune using either:
“Simple start” if you are applying standard optimization goal settings.
“Custom start” if you are applying special/custom rules to specified queries.
Run the application, queries, or stored procedure you are tuning.
Collect the metrics into specified XML files. See “Collecting metrics”.
Compare the sets of metrics you have collected for different optimization goals. This step uses the XML file from the above step as input, and generates a performance comparison report. See “Comparing metrics”.
Apply the best results from the comparison to each of the specified queries on the target server. See “Applying the best results”.
QPTune’s tuning cycle for applications or queries is shown here:
Figure 2-2: QPTune cycle for application or query tuning
