Memory mapped file almost increased to the size of physical memory RRS feed

  • Question

  • We are implementing a new SQL ETL process for our BI platform and are currently executing a basic "SELECT x, y FROM z " from a handful of tables.

    we are observing process's working set RAM footprint continually increases until it levels off at roughly physical memory size. Through RamMap tool we seen standby memory grows more rapidly than active memory. Is this expected behaviour? Is there any way to limit memory mapped size ? What exactly is active memory and standby memory ? 

    Please help me  to find these answer

    Wednesday, May 23, 2018 4:39 PM