Post reply

Too many ISServerExec.exe processes

  • November 4, 2019 at 10:02 pm

    #3694505

     

    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

    #3694519

    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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • November 4, 2019 at 11:06 pm

    #3694524

    this will be interesting reading https://docs.microsoft.com/en-us/sql/integration-services/data-flow/data-flow-performance-features?redirectedfrom=MSDN&view=sql-server-ver15

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply