SQL SERVER – Integration Services Balanced Data Distributor – SSIS Balanced Data Distributor

SQL SERVER - Integration Services Balanced Data Distributor - SSIS Balanced Data Distributor scale Microsoft SSIS Balanced Data Distributor (BDD) is a new SSIS transform. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading. The transform takes one pipeline buffer worth of rows at a time and moves it to the next output in a round robin fashion. It’s balanced and synchronous so if one of the downstream transforms or destinations is slower than the others, the rest of the pipeline will stall so this transform works best if all of the outputs have identical transforms and destinations. The intention of BDD is to improve performance via multi-threading. Several characteristics of the scenarios BDD applies to: 1) the destinations would be uniform, or at least be of the same type. 2) the input is faster than the output, for example, reading from a flat file to OleDB.  An updated version of Microsoft SSIS Balanced Data Distributor (BDD) is available. This includes a fix for the problem causing BIDS to crash when removing the BDD transform

Download SQL Server Integration Services Balanced Data Distributor

Let me know what you think of this blog tool and utility. Do you use them in production server? If yes, I would like to know the scenario.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Documentation, SQL Download, SQL Server, SSIS
Previous Post
SQLAuthority News – Presenting at Tech-Ed On Road – Ahmedabad – June 11, 2011 – Wait Types and Queues
Next Post
SQL SERVER – PHP on Windows and SQL Server Training Kit

Related Posts

1 Comment. Leave new

  • shashankpaturkar@live.com
    December 30, 2011 9:19 am

    Hi,

    I have tried to install the x86 version of the BDD on one of my Server *64bit, SQL Server 2008 R2), but it fails to install.

    Gives message “Installation is not Sucessfull” Check if BIDS or SSIS is installed or the Component Version is not SQL Server 2008 or SQL 2008 R2 or Higher SP.

    Reply

Leave a Reply

Menu
Exit mobile version