A Case Study on Building a Highly Scalable Enterprise Application that uses Massively Parallel Processing (MPP) to Deliver High Performance and Scalability on SSIS-SQL Server 2012
Summary: `This paper shares the approach used to understand and determine:
- Using the new Data Flow transformation component – Balanced Data Distributor (BDD) in SSIS-SQL Server BIDS-2008/2012, including performance analysis.
- Understand the specifics involved while leveraging BDD to build a highly scalable enterprise application that uses massively parallel process (MPP) to deliver high performance and scalability on SSIS.
BDD is a simple and new Data flow component that can have huge benefits when working with data that is takes too long to load in a single Data Flow. The intention of BDD is to improve performance through multi-threading. This white paper describes the scenario and the pattern where BDD can be leveraged in SQL 2008/2012. It also includes the challenges and best practices when considering BDD to build enterprise solutions, as well as the performance analysis at different stages.
This content is suitable for developers, architects, and database administrators. It is assumed that readers of this white paper have basic knowledge of SQL Server 2008/2012/2014 and SQL Server administration.
Authors: Prabhakaran Sethuraman (PRAB), Microsoft
Technical Reviewers: Prabhakaran Sethuraman (PRAB), Microsoft | Shubhra Mittal, Microsoft | Mohammed Maqsood, Microsoft | Hariharan Sethuraman, Microsoft | Mandi Ohlinger, Microsoft
Published: September 2014
Applies to: SQL Server 2008, SQL Server 2012, and SQL Server 2014
To review the document, please download the A Case Study on Building a Highly Scalable Enterprise Application that uses Massively Parallel Processing (MPP) to Deliver High Performance and Scalability on SSIS-SQL Server 2012 Word document.