Montag, 25. Februar 2008

SSIS: chaching options versus network traffic

So, i'm still worrying about the different caching options (full, partial, none) of SSIS. With my current configuration (full caching), i am facing out of memory exceptions (at least sometimes, when things are going really bad).
But changing the settings to "partial" creates another problem: since SSIS and SQL are not running on the same machine, the new settings will increase network traffic (singleton queries).
Mh, i am really curious about which way to go. I will let you know when the time has come. Any kind of help is welcome :).

Keine Kommentare: