December 28, 2015 at 5:14 am
hi all,
Is the memory used by SSIS independent of SQL server Engine?
December 28, 2015 at 7:43 am
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
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