SSIS Memory used

• ram1447

  SSC-Addicted

  Points: 499

  More actions

  December 28, 2015 at 5:14 am

  #310449

  hi all,

  Is the memory used by SSIS independent of SQL server Engine?

• Phil Parkin

  SSC Guru

  Points: 247122

  More actions

  December 28, 2015 at 7:43 am

  #1848248

  ram1447 (12/28/2015)

  ---

  hi all,

  Is the memory used by SSIS independent of SQL server Engine?

  Yes, as far as I know. SSIS packages are executed by dtexec.exe, which is separate from the other SQL Server processes.

  ---

• Eric M Russell

  SSC Guru

  Points: 125589

  More actions

  January 7, 2016 at 11:23 am

  #1850284

  Yes, data buffers allocated by SSIS during execution consume memory separate from that reserved by SQL Server, which is why it's reccomended that SSIS be installed on a separate server.

  "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho