Welcome to Embarcadero® Performance Center 2.7.1™

Performance Center Web Site | Embarcadero Technologies Home | Technical Support

Published: July 22, 2009

Thank you for using Embarcadero Performance Center, an enterprise DBMS monitoring and performance management system that enables the proactive and reactive monitoring, diagnosis, and management of multiple Oracle, SQL Server, Sybase, and DB2 UDB LUW databases in real time. Embarcadero Performance Center is equipped with intelligent diagnostics and expertly designed tuning guidelines; including performance threshold violation detection, alarms, notifications, and powerful reporting mechanisms, all intended to help pinpoint and solve every performance problem you face.

What's New in Version 2.7.1

Improved Actions Functionality Scripts

Support for Oracle 11g Server

Creating a Performance Center Repository without Sysadmin Privileges

Monitoring User is no Longer Automatically Granted Privileges

Release Notes

System Requirements

DBMS Support

Known Issues

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in Version 2.7.1

Improved Actions Functionality Scripts

The new wizard allows you to: (1) add a command and attach it to an alert; (2) run a specific SQL when an alert is active; and (3) start DBOptimizer Profiling when an alert is active.

Under the new action scripts setup, you are still able to execute a SQL script using the arbitrary command execution. However, now you can create a new SQL action with a specified script from the Performance Center client. Actions that execute arbitrary commands are now easier to use. Rather than requiring that the action include the logic to send an email to notify the user, the standard output is now captured from the command and attached to the action notification. Furthermore, a more obvious and simplified "Profile with DBOptimizer" action type dialog is provided to use with DB Optimizer. You can now create and edit an action through a two-step wizard.

Support for Oracle 11g Server

Performance Center now supports the Oracle 11g Server. NOTE: Performance 2.7.1 does not support Oracle 11g Client.

Creating a Performance Center Repository without Sysadmin Privileges

Sysadmin privileges are no longer required when creating a new Performance Center repository using the default setup. In particular, it is no longer required that a new user must be created during default setup. Instead, any user with the required privileges may be used.

Monitoring User is no Longer Automatically Granted Privileges

In previous releases, when registering a datasource, Performance Center would require a sysadmin login to the datasource in order to grant the privileges required for monitoring to the monitoring user. Now, when registering a datasource, you may use an existing user (created separately) who already has the privileges required for monitoring (for example, if this datasource was previously registered with Performance Center). Furthermore, you can click Privileges to view a script that grants the required privileges to the monitoring user (and creates any auxiliary objects required for monitoring).

Release Notes

System Requirements

The following are the minimum hardware and system requirements to run Performance Center:

• Microsoft Windows Server 2000, 2003, XP, and Windows Vista (Aero and Basic)
• 512 MB of RAM
• 250 MB of hard disk space (more space is recommended in large environments)
• Database vendor-specific middleware for connectivity to repository and monitored data sources

The following are the minimum hardware and system requirements to run Performance Center Client:

• Microsoft Windows Server 2000, 2003, XP, and Windows Vista (Aero and Basic)
• 64 MB of RAM
• 75 MB of hard disk space

DBMS Support

Performance Center supports the following platforms:

• Oracle 8i, 9i, 10g, and 11g
• Sybase ASE 12.0, 12.5, 15
• IBM DB2 for LUW 8 and 9
• Microsoft SQL Server 2000, 2005, and 2008

Known Issues

• When installing Performance Center, IIS 7 is not supported and Apache should be used instead.
  
• A known issue causes problems with the installation program. The following measures should be taken if Performance Center does not install or uninstall properly:
  
  Problem: Embarcadero Performance Center does not uninstall and starts the validation of the Performance Center installation.
  Solution: Remove the validation key HKEY_CURRENT_USER\Software\Embarcadero\Performance Center\2.6\InstallationOptions\Validator.
  
  Problem: Embarcadero Performance Center setup does not install/copy all files. An error message indicates it cannot register a list of DLL files.
  Solution: Remove the validation key HKEY_CURRENT_USER\Software\Embarcadero\Performance Center\2.6\InstallationOptions\InstallPreReqReboot.
  
  Problem: Embarcadero Performance Center does not install, but opens the uninstall window.
  Solution: Remove the uninstall key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{0D57C744-A9F6-4D3D-A86A-C8E45214EBA8}
  
  Problem: Embarcadero Performance Center fails to install with unknown causes. Running the installation and uninstallation programs do nothing, and the solutions provided above do not help.
  Solution: Follow the steps below:
  
  1. Remove HKEY_CURRENT_USER\Software\Embarcadero\Performance Center.
  
  2. Remove the following Paul Bunyan keys:
  
  HKEY_LOCAL_MACHINE\SOFTWARE\Diamond Sierra\Paul Bunyan
  HKEY_LOCAL_MACHINE\SOFTWARE\Levons Wake
  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\Paul Bunyan
  HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\Paul Bunyan
  HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Paul Bunyan
  HKEY_LOCAL_MACHINE\SYSTEM\ControlSet003\Services\Eventlog\Application\Paul Bunyan
  HKEY_LOCAL_MACHINE\SYSTEM\ControlSet003\Services\Paul Bunyan
  HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\Paul Bunyan
  HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Paul Bunyan
  
  3. Delete the shortcut located in Start\Programs\Startup\Server Status.
  
  4. Restart the machine.
  
  5. Stop the 'Embarcadero Performance Center' service.
  
  6. Stop the ETPMonSvc.exe process via Task Manager.
  
  7. Delete all of the files from the Program Files\Performance Center directory.
• There is a known issue when attempting to register a DB2 UDB LUW database that is at release level v8.2.0003 and later (v8.1 Fixpack 10 and later). Performance Center reports an error when trying to populate the list of available database login IDs. This is a known issue since the introduction of Fixpack 10, and is related to a post-installation task that needs to be performed against the DB2 server. In order to resolve this issue you must follow the post-installation tasks in the DB2 Fixpack ReadMe file related to binding package "db2schema.bnd", and grant access to this package to PUBLIC:
  
  db2 BIND /db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror continue
  
  This action only needs to be performed once for every database in the DB2 server, not for all clients.
  
  
• When installing Performance Center using domain user account authentication, do not use a user account that is subject to password change policies. If the password changes, the Performance Center service will not restart. Workaround: Uninstall Performance Center and reinstall using the new password.
  
  
• There is a known issue when attempting to register a DB2 UDB LUW database that is at release level v8.2.0003 and later (v8.1 Fixpack 10 and later). Performance Center reports an error when trying to populate the list of available database login IDs. This is a known issue since the introduction of Fixpack 10, and is related to a post-installation task that needs to be performed against the DB2 server. In order to resolve this issue you must follow the post-installation tasks in the DB2 Fixpack ReadMe file related to binding package "db2schema.bnd", and grant access to this package to PUBLIC:
  
  db2 BIND /db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror continue
  
  This action only needs to be performed once for every database in the DB2 server, not for all clients.
  
  
• When installing Performance Center, if IIS is the default web server, it is strongly recommended that an actual domain user is selected to run the service, and not the Local System account. Also, that user must be in the administrators group.

Bug Fixes

Additional Resources

Licensing Your Embarcadero Technologies Product

All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. See the steps outlined below to license Performance Center. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] and [email protected] for sales in the EMEA and Asia-Pacific regions, respectively.