Profiling and Discovery Sizing Guidelines

Back Next

Sizing Guidelines for Profile Deployments

The sizing guidelines help you to determine the system resources for the Profiling Service Module and Data Integration Service for different profile deployments.

The examples include multiple profile deployment scenarios based on the type of profile deployment and size of the organization. Each deployment scenario describes the typical setup definition and recommended configuration settings for the sizing parameters.

Consider the following examples:

Individual Profile Sizing Example: Few individual users in a department of a small organization. Profile activities include running a column profile on flat files and relational databases with up to 10 million rows.
Departmental Profile Sizing Example: A competency center in a medium to large organization or a small department in a large organization. Profile activities include running profiles on medium to large data sources with 50 million to 1 billion rows.
Corporate Profile Sizing Example: Large scale organization with data stewards that run profiles and scorecards daily. Users include 40 to 60 data stewards that use the Analyst tool and one to three power users that use the Developer tool. Profile operation is on a single, high-end node connected to the database servers.
Enterprise Profile Sizing Example: Large scale organization with data stewards performing profile and scorecard runs daily. Users include 30 to 40 data analysts that use the Analyst tool and 5 to 10 data architects that use the Developer tool. Profile operation is on a grid configuration.