SQL Server MemToLeave

If you find yourself running out of memory in linked server queries, or in SSIS, look at this article.

Found through StackOverflow Question:

“Linked server queries use memory from an area outside of the SQL Server buffer pool called memToLeave, which is used for servicing connection threads and now the sql clr amongs other things. On 32-bit it's 384 MB in size which can be inadequate for some scenarios.

If you need to adjust your SQL Server Memory configuration and in particular the memToLeave area you will find an explanation on the following blog…”