November 4, 2019 at 10:02 pm
I am running into an issue where i see about 250+ ISServerExec processes running in parallel which i leading to 100% CPU. My questions are:
i) There are packages called via stored procedure from the app. Is there a way with in OS that i could limit ISServerExec.exe processes? I don't think MaxConcurrentExecutables would work here because the problem is in initiating the call to package. So far there isn't a way in the application to control this.
ii) May be resource governor?
November 4, 2019 at 10:34 pm
What do you want to happen in the event that a request to execute a package is received, but the 'maximum concurrent executions' number, whatever you deem that to be, has been hit?
November 4, 2019 at 11:06 pm
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply