On 10/30/2015 9:46 AM, Rallavagu wrote: > Also, this affects available physical memory as tlog continues to grow > and it is memory mapped.
I think this is a common misconception. MMAP does *not* use up physical memory, at least not in the detrimental way your sentence suggests. Any memory (OS disk cache) used when reading files this way can be immediately claimed by any program that needs it. https://en.wikipedia.org/wiki/Page_cache MMAP allows programs to allocate LESS memory, not more. It is far more efficient if there is spare memory that is not explicitly needed by applications, because of the OS disk cache. Thanks, Shawn
