Post reply

SSIS Memory used

  • December 28, 2015 at 5:14 am

    #310449

    hi all,

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

  • 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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply