Allocate memory for optimal system performance and configure error tracing levels to reduce the number of log events generated by the Data Integration Service when it runs the mapping.

You can configure the maximum amount of memory that the Data Integration Service allocates for running all the concurrent requests. You can also limit the maximum amount of memory that the Data Integration Service allocates for any given request.

You can configure the result set cache, to enable the Data Integration Service to cache the results of the DTM process associated with each SQL data service query and web service request.