Scaling up is the ability of the Profiling Service Module to perform the same task proportionately faster after you add more resources to a single machine.

Scaling out indicates the ability of the Profiling Service Module to scale when adding more machines to it. Similar to scaling up, doubling the number of machines halves the amount of time required to run a profile job.

The Profiling Service Module scales out in the following ways:

In the pushdown method, the Profiling Service Module sends a part of the profile job to the relational database for processing in the form of an SQL query. The Profiling Service Module processes the query results.

If the relational database has sufficient processing power, you can allocate more resources for the Data Integration Service where the Profiling Service Module runs. You can add more resources to a single node or add more machines to a grid. If the performance limitation is the processing power of the relational database, the machine running the relational database requires more resources.