Can lots of merge results cause high CPU usage

Knowledge Drop

Last tested: Oct 28, 2020
 

Answer is yes!

Merge results are performed in memory and not in SQL on the database. We store the results of all the source queries in memory and then merge those source queries in memory. The usage of this memory can cause the memory to be throttled (essentially meaning that memory is used up to its max).

When the memory is throttled, it can trigger the garbage collector, and thus causes high CPU usage.

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:14 PM
Updated by: