How to Desc the memory Pressure in SSIS

• UmaJ

  Old Hand

  Points: 307

  More actions

  June 3, 2013 at 1:04 am

  #294125

  How to Desc the memory Pressure in SSIS ?

  1.Set the diff buffer max=0

  2.Reduce the engine threads

  3.Increase BLOB temp storage

  4.Reduce buffer size

• peterjonk

  SSCommitted

  Points: 1655

  More actions

  June 3, 2013 at 3:01 am

  #1620420

  Not really en expert on this subject, but this article may help you.

  http://www.mssqltips.com/sqlservertip/1867/sql-server-integration-services-ssis-performance-best-practices/[/url]

  __________________
  MS-SQL / SSIS / SSRS junkie
  Visit my blog at dba60k.net