Sample Header Ad - 728x90

How to best manage a queue of external processes

0 votes
1 answer
53 views
My scenario is a web app that creates jobs that need to be processes by an R script. We are currently have the web app execute a SQL stored proc that executes the R script. However, we quickly realized this is unworkable. The first job eats a lot of memory up and then all subsequent jobs fail. We did set aside 40% of the servers memory for external processes, as described in MSFT's docs here: https://learn.microsoft.com/en-us/sql/advanced-analytics/administration/how-to-create-a-resource-pool?view=sql-server-2017 I appreciate any advice or recommendations you may have.
Asked by tnk479 (143 rep)
Nov 30, 2018, 08:19 PM
Last activity: Nov 30, 2018, 10:30 PM