BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20130504T071000Z DTEND:20130504T081000Z LOCATION:SQLBits Conference - Suite 4 SUMMARY:Scaling Out SSIS With Parallelism DESCRIPTION:An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques. This will also cover how to achieve elastic style scale out and how well different approaches scale across CPU cores, including scaling with hyper threading turned on and off and an investigation into what the the affects of L2 cache splitting. Comparisons will be drawn between achieving parallelism using SSIS and the query execution engine, specifically around parallelism start up costs, partitioning workloads between threads and the impact of serial regions on the throughput of parallel schemas.
X-ALT-DESC;FMTTYPE=text/html:

Scaling Out SSIS With Parallelism

An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques. This will also cover how to achieve elastic style scale out and how well different approaches scale across CPU cores, including scaling with hyper threading turned on and off and an investigation into what the the affects of L2 cache splitting. Comparisons will be drawn between achieving parallelism using SSIS and the query execution engine, specifically around parallelism start up costs, partitioning workloads between threads and the impact of serial regions on the throughput of parallel schemas.

Chris Adkin

Chris is a free lance devleoper / DBA with a passion for squeezing performance out OLTP applications which he has practised over a fifteen year career over a variety of sectors within IT.

UID:SQLBITS1514SEQUENCE:0 DTSTAMP:20130525T200924Z END:VEVENT END:VCALENDAR