[dba-SQLServer] DTS Connections and performance

With DTS IME if i have more than a single connection I can get data pumped
over xNumber Of Connections, that is, if I have several tables I may create
2 or 3 connections... this makes it so I have data traveling accross x3
instead of each at a time... Depending on what you are doing in the
datapump, you can increase the performance ie, throughput on how much data
gets processed.

--
Francisco

On 2/1/06, Mark.Whittinghill at protective.com <
Mark.Whittinghill at protective.com> wrote:
>
> In a DTS I have multiple simultaneous data pumps from the same connection.
> Is there any performance difference in having them all reference the same
> connection, or in creating a new connection for each pump, with the same
> connection info.  As I set all connection info from an ini in a Dynamic
> Properties Task, managing a few connections is a lot easier than having
> 50.
>
> Thanks,
>
> Mark Whittinghill
>
>


--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...