Performance Tuning Guide

Back Next

Recommendations for Environment Validation Tools and Utilities

You can verify the current environment and identify the area of improvement by using different tools and utilities.

The following table lists the recommendations related to the database:

Parameter	Recommended Setting	Description
Test IO (utility) applicable for Oracle	Available from Informatica Support.	Test the datafile input/output (I/O) capability of the data files of the database tablespaces by referring to the Informatica Knowledge Base article number 506035. The test result must meet or exceed the standards documented for 'Good Performance' seen in the Informatica Knowledge Base article number 506035.
Ping/TraceRt	Response Latency must be less than 10 milliseconds.	Run a ping or tracert (Trace Route) to MDM Database ( CMX_SYSTEM ) and individual ORS from application server box.
Test specific disk partition IO	Reasonable MB/second.	Follow the instructions in the Informatica Knowledge Base article number 139805 to test all disk partitions involved in the MDM Hub, including partitions where tablespaces reside and where the database debug log is written. If greater than 10 Mb/second, that specific partition needs to be fixed.

The following table lists the recommendations for the Hub Server and the Process Server:

Parameter	Recommended Setting	Description
Ping/TraceRt	Response Latency must be less than 10 milliseconds.	Run a ping or tracert (Trace Route) to the MDM Hub Server or the Process Server from client box or the Hub Server box. Repeat this step for the following boxes wherever applicable: All nodes in a cluster Load balancer Web Server