SSIS dataflow Performance tuning
Course description
This workshop will guide you through a number of dataflow optimizations you have to address
if you don't want to run into problems when your solution needs to scale because of increasing data volumes.
This workshop is based on a presentation Geert Vanhove has given during the SQL Server OpenWorld 2007 conference in Lalandia
, Denmark and was also selected for the upcoming 2008 European PASS Conference in Dusseldorf, Germany.
Target audience
Developers who are uncertain their functionally working SSIS packages will perform accurately when data volumes will
increase and can't spend too much time investigating the ins and outs of the SSIS dataflow engine.
Content
See lookup caching in action
Optimize data sources
Compare different data flow destinations
Analyze and evaluate memory buffer settings
Location:
At the DCOD office in Herk-de-Stad or on-site
Duration:
1 day
When:
On demand on weekdays or Saturday (min 4 attendees on weekdays)
Price:
€600 / attendee
|
