Dedicated SSIS server - Allocating RAM

• cbarus

  SSCommitted

  Points: 1909

  More actions

  June 7, 2012 at 2:05 pm

  #257565

  We have a dedicated SSIS Server that is running on SS2008 SP1, W2008 Enterprise. It has total of 8GB of RAM. How much is recommended to be allocated to SQL Server? If I leave the rest unassigned, does SSIS get to use that memory along with the OS? Is there a separate configuration for SSIS?

  Thanks for your time

• Jo Pattyn

  SSC-Dedicated

  Points: 32350

  More actions

  June 7, 2012 at 4:03 pm

  #1498441

  I have no experience with SSIS but would leave a minimum of 2 GB for the OS/other applications (max memory<6 GB).

  Have a look at

  Sql server best practices on technet

  MSDN

  Specific on dedicated SSIS