Windows Server 2012 R2 ,SQL Server 2012
I am running into an issue with a child process called 'ISServerExec', which is spawned from the 'sqlservr.exec' process... The short story is that ISServerExec will not terminate after an SSIS job completes. The process will eventually consume all CPU causing the node to die causing a failover. I have tried adding code to kill these rogue ISServerExec processes, but I get messages that state that the processes cannot be terminated. Here are example statements for both command line and powershell steps generated by a job to kill the rogue processes:
EXEC master.dbo.xp_cmdshell 'TASKKILL /pid 7000 /f /t'
Both commands return the message - ' ERROR: The process with PID 7000 (child process of PID 5894) could not be terminated.'
The process tree shows that PID 7000 (ISServerExec) is a child process from 'sqlservr.exe' -PID 5894 - Of course, I don't want to kill my SQL instance, just to kill ISServerExec...
Any ideas or thoughts to address with would be helpful...