Pro Programmer: Performance Tuning in SSIS

Tuesday, August 14, 2012

Performance Tuning in SSIS

Well this is a very broad subject. Basically you're finding out what is running slow and eliminate whatever is causing the slowness. When performance tuning a data flow, the goal should be to pass as many records as possible through  a single buffer while utilizing memory. Proactive caching also supports great performance. Wrong data types and size can also affect performance.

I'll come back to this one shortly...

No comments:

Post a Comment