Embarcadero Performance Center ReadMe

Welcome to Embarcadero® Performance Center 2.7™

Performance Center Web Site | Embarcadero Technologies Home | Technical Support

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

SQL Text Capture in a 24/7 Environment

Continued Stabilization of Performance Center

Improvements to User Interface

Controls Added to the Threshold Setup and Criterias

Microsoft Vista Compatibility

Release Notes

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

SQL Text Capture in a 24/7 Environment

SQL Text capture is now available in a 24/7 environment. The SQL Capture is triggered by a threshold violation. When such a violation occurs, a SQL Capture session is triggered and collects performance-related data for the SQL running currently on the datasource that fired the threshold.

Continued Stabilization of Performance Center

Behind-the-scenes work was done to improve the stablization of the application.

Improvements to User Interface

There have been numerous user-interface improvements that make Performance Center easier and faster to use. Some of the major improvements are:

An aggregated historical tab has been added that combines metrics for historical comparisons.
On the Web Client, multiple tables are now shown on a single page so the content is better organized and shows more information per page. You can also now view full-screen charts.
The Enterprise View now includes critical alert events and conditions. This allows support desk personnel to monitor and react to actionable events without the need to cycle through all the instance views.

Controls Added to the Threshold Setup and Criterias

The threshold setup and criteria now uses Alerts as the notification driver. When a threshold is violated the alert triggers an email when a threshold is first violated, and then again when the violation changes, or if the severity of the violation changes. You can now choose to receive continuous notifications during the threshold violation by specifying a reminder. Or you can disable reminders so you are only notified when threshold violations start, stop, or change.

Microsoft Vista Compatibility

Performance Center is now compatible with both Microsoft® Vista Aero™ and Visa Basic.

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, and 10g
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

Bugs Fixed in Version 2.7
Bug	DBMS	Version	Description
574	All	All	Manage with DBArtisan not functioning when DBArtisan is not running.
589	Oracle	All	PC 196 BUG - The customer's Oracle datasources take a long time for the data to get populated. Sometimes it is an hour or more after starting up the Performance Center Client.
637	All	All	Would like ability to avoid duplicate email notifications.
1972	All	All	Would like to be able to get a notification when an alert has been cleared.
2289	SQL Server	All	Performance Center is generating blocks on a production server.
2809	All	All	Customer is having issues sending notifications to Tivoli, which in turn sends information to their notification system.
4099	All	All	OS_MONITORING: Linux OS - Processor time is 10600.00%.
4100	All	All	OS_MONITORING: Linux OS - CPU Utilization time at 1600% and 9000%.
4102	All	All	REPORTS: Unable to run reports due to baseline date discrepancy.
4120	Sybase	All	Web client - datasource page not updated since datasource was disabled and re-enabled.
4121	All	All	INSTALL: Down datasource being incorrectly reflected as "up and connected".
4148	SQL Server	All	INSTALL: Have to manually restart Performance Center after installation to successfully connect to Repository.
4156	Sybase	All	HOME_PAGE: Sybase "Large I/O hit rate" value is incorrect.
4817	All	All	Performance Center shuts down frequently.
5623	All	All	User was forwarded email message from EPC indicating a licensing issue - data appears to be lost and the PC service restarts.
5719	All	All	OS_Monitoring - Linux OS: Processor time incorrectly indicates 4600.00%.
5720	Sybase	All	Contention page shows several statistics > 100%.
Bugs Fixed in Version 2.6.2
Bug	DBMS	Version	Description
4093	All	All	Getting an error "Exception caught: Number: -2147467259 Source: Description LastDllError()" during the installation of Performance Center.
5600	All	All	Getting 0 datasources when using
Bugs Fixed in Version 2.6.1
Bug	DBMS	Version	Description
4101	All	All	DATASOURCE_REGISTRATION: Registered new DS not displayed until Performance Center is restarted.
4205	All	All	No scroll bar appears in Web Client when there are many data sources and the Web Client is maximized.
4801	All	All	OS Monitoring continues after datasource is disabled.
4953	All	All	Chart graph from previous Historical report used when new report is generated.
4954	All	All	Export Report options not available in 2.5.2 Historical Reports.
5077	All	All	Cannot add periods to Enterprise Database Availability Comparison to Baseline report.
4254	Oracle	10g	ALERTS: Deadlock violated threshold of 0 with a value of 3.28947368421053E-03.
4774	Oracle	10g	Statistic "Free memory" SQL not correct for Oracle 10 sga_target - returns error.
4792	Sybase	12.5	WEB_CLIENT: Graphs are not automatically refreshed.
4795	Sybase	12.5	WEB_CLIENT: All values/graphs seem to increase all the time.
Bugs Fixed in Version 2.6
Bug	DBMS	Version	Description
4110	All	All	Home Page: Error "[DATAABS-3092] Unable to acquire statistic value for stat id".
4179	All	All	CLNTSERV and CLTRTER errors when right-clicking datasource and selecting threshold.
3241	All	All	Web Client crashes every night - have to restart Apache and Performance Center.
3715	DB2	V9	PC250 3509: No data is being stored in the Repository database.
4558	Oracle	All	Getting an error when trying to register an Oracle database "Failed to initialize OCI Layer".
4217	Oracle	All	Contention Health Index always shows 0% on all datasources.
3368	Oracle	All	DATASOURCE: Many CLTRTER-3106 & CLTRTER-3118 data conversion errors.
3369	Oracle	All	Error SFTTREE-3025 when attempting to drill down into Memory, I/O, and Users tabs.
2178	SQL Server	All	Stored Procedures getting overwritten constantly.
4134	SQL Server	All	Client is taking an hour or more to start and display in a large monitoring environment of a 100 plus datasources.
2112	SQL Server	All	Proc Plan Hit Ratio and Adhoc SQL Hit Ratio are incorrectly showing a NULL.
2177	SQL Server	All	REQ-4019 Cannot deploy the objects to datasource.

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.

Licensing Performance Center

Start > Programs > Embarcadero Performance Center > Performance Center.

Register

NOTE:

Register

Manage

Serial

Add

Register

NOTE:

Embarcadero Technologies Product Support

The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit www.embarcadero.com/support, or click any of the links below, to find:

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.

Embarcadero Technologies on the Web

To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.