Informatica products, such as the MDM Hub and Informatica PIM, have a high dependance on database for data storage. Consequently, the performance of the database affects the overall performance of the MDM Hub and Informatica PIM. To test the database performance, you can run the database performance testing utility that is in the Resource Kit.
The database performance testing utility is in the following directory:
On UNIX.
<Resource Kit installation directory>/utilities
On Windows.
<Resource Kit installation directory>\utilities
To check the input/output performance of the database, run the database performance testing utility. The database performance testing utility does not use the MDM Hub or Informatica PIM functionalities. The utility connects to the database by using JDBC. To assess the performance of the database input/output, the utility performs a load test that is independent of the MDM Hub and Informatica PIM.
The database performance testing utility performs a standard set of operations. The test is run with a known set of data. To determine the performance level of the database input/output, compare the test results against that of an Informatica benchmark environment. To compare the performance of your database environment with that of the Informatica benchmark environment, ensure that the conditions of the test environment are the same as that of the Informatica benchmark environment.