Integration of DB Optimizer with Performance Center requires that the following 3 directories be read and writeable:
a. Output directory
Given by the command line parameter “tofile: C:\DBO\output.oar”
• Given by the command line parameter “-data "C:\DBO\workspace”
c. Data source files
• Modifiable in DB Optimizer with the menu choice
If PC service runs as a local windows user who installed DB Optimizer, then it should be able, by default, to read and write to that users directories and no extra steps are necessary, but if the “Embarcadero Performance Center” service is running as “Local System” the files have to be located outside of the local users directory (because I have found no way to grant read and write to “Local System” on users directories except for sharing the directory on the network open to anyone)
For example if I, user “kyleh”, installed DB Optimizer on my desktop then my workspace and datasource directories would be in
C:\documents and settings\kyleh
More precisely :
Workspace ( by default)
The Performance Center service user, “Local System” can’t access these users directories, so I have to move these directories to a location such as:
NOTE: when setting up Performance Center to kick of DB Optimizer it's also useful to have email notifications set up:
In Performance Center Here are the steps you have to do:
1. In menu Monitor-> Server options -> Notifier tab you have to fill in the Host Name for the Mail server ( I remember I set it there when I was looking at the DBO actions)
Performance Center actions can be disabled by disabling the alert or by disabling the action. Make sure both the alert is enable as well as the action is enabled.
one way to somewhat simulate Performance Center services kicking off a DB Optimizer session is using the command
"at 00:00 /interactive cmd.exe"
which will open up a cmd shell as SYSTEM. LOCAL SYSTEM is who the Performance Center service runs as, so this is similar though not exact.