In our latest update one of our decisions is maxing out our memory limit and it looks related to sql we have in the process. Should we update this 'working memorylimit' or is there another way to analyze how many resources we are using on the system and optimize our process?
Thanks
ERROR App.TableServices.DS2.Runtime.Log Foursquare_Autodecision1_24 execute - [HY000] Error failed to create Nested Loop Join thread, system resources have been exceeded. The working memorylimit is 2048MB. (0x81bfc201).
2023-07-11T11:54:31,640 [00000008] ERROR App.TableServices.DS2.Runtime.Log Foursquare_Autodecision1_24 execute - Line 175: EXECUTE failed for SQL statement: