Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Multidomain MDM 10.4 HotFix 2
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Performance Tuning
  3. Recommendations
  4. Appendix A: Glossary

Performance Tuning Guide

Performance Tuning Guide

Back Next

Factors that Influence the Performance of the MDM Hub

Factors that Influence the Performance of the MDM Hub

The following table lists the different components that you can fine-tune to optimize the performance of the MDM Hub:
Components
Description
Java
Parameters that you can fine-tune in the Java layer. These parameters are applicable for the MDM Hub and for the Process Servers, including clustered environments.
General Database Recommendations
Parameters that you can fine-tune in the database layer. These parameters are related to sizing and storage.
Number of CPUs
Calculate this number as a number of simultaneously promoted ORSs +1.
Oracle
Parameters that you can fine-tune in the Oracle database, including the RAC environment. These parameters are applicable for both the MDM Hub Master Database schema and any Operational Reference Store (ORS) schema.
Microsoft SQL Server
Parameters that you can fine-tune in the Microsoft SQL Server. These parameters are applicable for both the MDM Hub Master Database schema and any ORS schema.
IBM DB2
Parameters that you can fine-tune in the IBM Db2 database. These parameters are applicable for both the MDM Hub Master Database schema and any ORS schema.
General MDM Server Recommendations
Recommendations related to the MDM Hub, the Process Server, and the Elasticsearch server environment.
The MDM Hub Specific Configuration
Parameters that you can configure in the MDM Hub. These parameters are applicable for both the MDM Hub Master Database settings and any ORS specific settings.
Batch Job Optimization
Parameters that you can configure for the better performance of the batch jobs.
Hub Console Optimization
Parameters that you can configure for the better performance of the Hub Console.
Informatica Data Director and Services Integration Framework or Business Entity Services Optimization
Parameters that you can configure for the better performance of Informatica Data Director with business entities or subject areas and Services Integration Framework (SIF) or Business Entity Services.
Environment Validation Tools and Utilities
List of tools and utilities that you can use to verify the current environment to identify the area of improvement.
0 COMMENTS
We’d like to hear from you!