Feed Tuning Tip

In the Data Pipeline, there is a switch called "SQL Memory Tune (GIG)". This switch allocates memory in Gigabytes to the DTS data pump engine. On a server with loads of memory, you can allocate more memory to the data pump than the default provides (the default is 1 gigabyte).

The data pump is used in the "Source to Stage" step of the feed, and the "Deployment to Production" step of the feed. By increasing this setting, you can boost the performance of each of these steps.

The correct allocation depends on the amount of available memory the database server has available. As a general rule of thumb, you want to allocate 1 gig for every 4 gig available on the machine. So on a server with 32 gig of available memory, you can allocate up to 8 gig for any given feed. Ultimately, you will have to test to get the right mix, as allocating too much can also affect server performance negatively; other services may me running and consuming available memory also (SQL Server, Analysis Services, O/S, etc...).