Table of Contents Previous Next


12 Tuning Wizard

Before using the Tuning Wizard, you must specify the name of the service in the Service ID field on the Server Properties dialog. PEM will use the name of the service when restarting the service after tuning.
To run the Tuning Wizard, select the Tuning Wizard option from the Management menu of the PEM client. The Tuning Wizard opens as shown in Figure 12.1.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\c5ef0c6f\twone.png
Click Next to continue to the server selection dialog (shown in Figure 12.2).

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\9818a1f9\twtwo.png
Expand the Servers node of the tree control to view a list of the servers that are currently monitored by PEM that are available for tuning. Check a box to the left of a server name to select the server for tuning. Use the Select all button to mark all servers for tuning, or the Unselect all button to clear all of the checkboxes.
Click Next to continue to the Machine Utilization dialog (shown in Figure 12.3).

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\d5663d15\twthree.png
Use the radio buttons on the Machine Utilization dialog to specify the type of work performed by the selected servers. The type of work performed by the server determines how the tuning wizard will allocate system resources:
Select the Dedicated radio button to dedicate the majority of the system resources to the database server.
Select the Mixed use radio button to dedicate a moderate amount of system resources to the database server.
Select the Developer workstation radio button to dedicate a relatively small amount of system resources to the database server.
Click Next to continue to the Workload Selection dialog (shown in Figure 12.4).

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\c7640b7b\twfour.png
Use the radio buttons on the Workload Selection dialog to specify the type of workload typically performed on the selected server:
Select the OLTP radio button if the selected server is used primarily to process online transaction workloads.
Select the Mixed radio button if the selected server provides a mix of transaction processing and data reporting.
Select the Data warehouse radio button if the server is used for heavy data reporting.
Click Next to continue to the Tuning Changes Summary dialog (see Figure 12.5)

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\88139105\twfive.png
The tree control on the Tuning Changes Summary dialog displays the servers analyzed by the Tuning Wizard, and the parameter setting modifications recommended for each server. Use the checkboxes next to a server or parameter name to select the recommendations that tuning wizard will either include in a preview report or apply:

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\8a9896b1\twsix.png
Select the Schedule changes radio button (see Figure 12.6) to enable the buttons in the Schedule selected tuning changes box and specify a time for PEM to apply the tuning wizard's recommendations and restart the server. Note that if you schedule a time for the changes to be applied, you will not be provided with a preview of the change recommendations.
Select the Configure tuning now radio button to instruct PEM to apply the recommendations and restart the server immediately. This is the default.
Select the Schedule it for some other time radio button to enable the calendar date and time selectors, and specify a time at which the changes will be applied and the server restarted. Once scheduled, the job can be viewed in the Scheduled Tasks dialog.
Select the Generate report radio button to enable the options in the Generate tuning recommendation report box and preview the changes recommended by the Tuning Wizard before applying any modifications. If you select Generate report, PEM will create a report that contains a list of the current values and recommended modifications to the configuration parameters selected on the Tuning Changes Summary dialog. Note that to implement changes, you will need to invoke the Tuning Wizard a second time, specifying the parameters you wish to modify on the Tuning Changes Summary dialog.
Use the options in the Generate tuning recommendation report box to specify if PEM should display the report onscreen immediately, or write the report to a file:
Select the radio button next to View the report now? to display the Tuning Wizard Report onscreen.
Select the radio button next to Save the report to a file: and specify a file location to instruct PEM to write the report (in html format) to file for review.
Click the Finish button to either apply the Tuning Wizard's modifications or generate a report immediately (see Figure 12.7) and exit the Tuning Wizard.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\396d46e8\Screen Shot 2015-12-15 at 10.20.14 AM.png
You can confirm that Tuning Wizard has implemented the recommended changes by reviewing the postgresql.conf file for the modified server. The Tuning Wizard adds a comment above each modified parameter in the postgresql.conf file when the change is applied (see Figure 12.8).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\316f5e7e\tuning.png
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\6c9bf36d\querytool.png

12 Tuning Wizard

Table of Contents Previous Next