SQL Agent Job and SQL Memory

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.

Answer 1

The SSIS packages will run in a different context and will not use the memory allocated to SQL server.

Answer 2

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 [e-mail].