Enable Memory Restriction for Lookup Transformation
- From: Manan <shah.manan.i@xxxxxxxxx>
- Date: Thu, 1 May 2008 03:28:48 -0700 (PDT)
Hi,
We can enable memory restriction (limit cache size) for “Lookup
Transformation" in Data Flow Task, can someone tell me how exactly it
effects the performance of the package?
I’m fetching 35 million records from source database and having lookup
against table which has almost 45 million records. So when I’m
executing the package, for first couple of minutes (approx 5-10 mins)
it caches the lookup table and then fetches the records from source
db, perform the real lookup and send it to destination.
Can someone tell me if I enable memory restriction on lookup
transformation how exactly it will perform lookup on record set which
is not cached and is there any risk in enabling the memory
restriction, I mean it may not be able to perform lookup up on non
cached data or something like that, is there any performance benefit/
drawback while enabling it?
As I'm new to SSIS & so may be my question sound very basic, silly or
repetitive so sorry for that.
Thanks in advance.
Cheers,
Manan
.
- Follow-Ups:
- Re: Enable Memory Restriction for Lookup Transformation
- From: jhofmeyr
- Re: Enable Memory Restriction for Lookup Transformation
- Prev by Date: SSIS - it's magic really
- Next by Date: Re: changing SQL Agent 'Logon as' to move backups off same drive,j
- Previous by thread: SSIS - it's magic really
- Next by thread: Re: Enable Memory Restriction for Lookup Transformation
- Index(es):
Relevant Pages
|
