Download View this document as PDF

QPTune GUI
•
Click on your server name. You see the Tuning tasks tab.
Note If you do not see the Tuning Task tab, please check that your
environment variables are set correctly and that your installation contains
all the required files and directories.
•
Click on the Tuning Tasks tab, and then right-click in the window to bring
up the “New”-> “TuningTask” menu item.
•
Select the “New”-> “TuningTask” menu item. The QPTune Wizard opens.
Alternately, you can bring up the Wizard using the “Tuning Task” creation
button that is provided on the toolbar.
Note You must have sa_role and sso_role to use the menu item and the creation
toolbar button.
The QPTune wizard includes these screens corresponding to the different
stages in tuning the Adaptive Server:
•
Setup:
•
Name and Configuration
Specify the task name and the configuration file associated with the
task. When these are both specified, the Next and Finish buttons ar
enabled. If the configuration file already exists, the wizard indicates
this by displaying a note under the file name.
You may select the Verbose Mode option to generate more detailed
output.
•
Server Configuration
You can view or edit server configuration commands issued during
the different stages of running QPTune. Changes to the commands are
written to the configuration file right before execution on the
Comparison page.
•
Mode Selection
You may select different modes to run QPTune. All three preprogrammed modes are selected by default:
48
•
Decision Support System (DSS)
•
Online Transaction Processing (OLTP)
Adaptive Server Enterprise