Execution Trees


Interrelated components are clustered in a package to form execution trees. Upon careful examination, you will find that some of these source adapters, transformations, and destination adapters might have no dependencies at all. Other components might have fewer linear dependencies than originally thought. Generally, each source adapter will be assigned a separate thread of execution. Destination adapters and asynchronous transformations will also be assigned separate threads. Multithreaded operations have the advantage of using the computer's processor(s) more efficiently with instructions executed in parallel.

Separate memory buffers enable threads to operate on data independently and in parallel. Use the multicast transform to generate multiple buffers. This is one of the easiest and most efficient ways to allocate additional memory buffers and to cast multiple execution threads to use the server's physical resources efficiently to improve performance.




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net