SSIS not using memory beyond 4GB

• light_wt

  SSC Eights!

  Points: 970

  More actions

  October 14, 2009 at 8:34 am

  #156315

  I have a 32bit OS Windows 2008 ent with 16 GB RAM.

  Taskmgr sees all 16 GB of RAM because PAE is enabled. AWE, lock pages in memory, Create Global Objects are enabled for Everyone.

  I have set MAX memory on SQL to use 7GB. It is using only 1.3 GB (as if getting memory under the 4GB)

  Running the package from BIDS, I don't see Physical Memory used beyond 4GB and the package runs very slow.

  Is there step that is missing to let SSIS use memory beyond the 4GB?

  Thanks.

• October 14, 2009 at 10:02 am

  This was removed by the editor as SPAM

• October 14, 2009 at 10:58 am

  This was removed by the editor as SPAM

• October 15, 2009 at 10:40 am

  This was removed by the editor as SPAM

• October 16, 2009 at 6:26 am

  This was removed by the editor as SPAM