BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

Balanced Data Distributor: Improve SSIS Performance with Parallelism

| by Jenni Konrad on Jun 02, 2011. Estimated reading time: 1 minute |

The Balanced Data Distributor (BDD) is a new multithreaded data flow transform tool for SQL Server Integration Services (SSIS). It’s intended to improve performance in multi-core and multi-processor server environments by distributing data to multiple outputs.

The Balanced Data Distributor takes advantage of parallelism to speed up data transformations, so it won’t have an effect on single-processor configurations. (In fact, it could degrade performance versus a straight insert using a Script Component in SSIS.) Microsoft recommends using this particular transform only in specific circumstances. An appropriate scenario involves all of the following criteria:

  • There is a large volume of data to be moved.
  • The data can be read quickly (from a flat file, for example), but there is a potential bottleneck in the transformation process or the destination. 
  • The order of the source data does not need to be maintained (BDD splits it into roughly equal buffers).
  • The destinations should all be uniform, or of the same type.

On his blog, Boyan Penev provides an introductory performance comparison of the BDD versus an insert using a Script Component. He saw a 35%-45% performance increase using a local SQL Server instance. The SQL Server Performance Team provides more information on best practices for using the Balanced Data Distributor in parallel environments.

The Balanced Data Distributor transform is currently only available for SSIS 2008.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

MapReduce by Yuheng Zhang

This is mapReduce mechanisam, MS apply it into SSIS

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

1 Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date with curated articles from top InfoQ editors

"You dont know what you dont know" change that by browsing what our editors pick for you.

BT