Hello,
I was wondering if there was a setting or a way to limit or restrict the amount of Memory an SSIS package can use? I know that by default the windows OS limits a process (a package in this case) to 2GB and up to 3GB with AWE enable but what if I wanted to say Limit it to 1GB of memory is there anyway to do that? Is there an SSIS Engine setting or Package property somewhere?
Thanks!
See if this helps you. Check out the Buffer size section in this paper:http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx
No comments:
Post a Comment