none
SQL Agent Job and SQL Memory RRS feed

  • Question

  • We have several SSIS packages called from SQL Agent Jobs in SQL 2014 Enterprise.

    We have 20240 defined as maximum memory setting of SQL Server.

    When these SSIS packages run as a SQL Agent Job will they use  the 20240 or the memory not used by SQL Server.

    Thanks.


    • Edited by miguelh Tuesday, June 20, 2017 10:27 PM
    Tuesday, June 20, 2017 10:26 PM

Answers

  • Hi miguelh,

    SSIS runs outside of SQL Server's memory space so it's going to be contending with memory allocated to the OS.

    How much memory you allocate to SSIS is entirely dependent on how you define your SSIS packages. The  SQL Server max server memory is used for buffer pool mainly. See: Effects of min and max server memory

    So, in this scenario, SQL Server Agent job won't use the 20240 memory.

    If you still have any questions, please feel free to ask.

    Best Regards,

    Pirlo Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by miguelh Thursday, June 22, 2017 12:38 PM
    Wednesday, June 21, 2017 3:26 AM
    Moderator

All replies

  • The SSIS packages will run in a different context and will not use the memory allocated to SQL server.
    Tuesday, June 20, 2017 10:43 PM
  • Hi miguelh,

    SSIS runs outside of SQL Server's memory space so it's going to be contending with memory allocated to the OS.

    How much memory you allocate to SSIS is entirely dependent on how you define your SSIS packages. The  SQL Server max server memory is used for buffer pool mainly. See: Effects of min and max server memory

    So, in this scenario, SQL Server Agent job won't use the 20240 memory.

    If you still have any questions, please feel free to ask.

    Best Regards,

    Pirlo Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by miguelh Thursday, June 22, 2017 12:38 PM
    Wednesday, June 21, 2017 3:26 AM
    Moderator