It turned out that another user runs his stored process via SAS Add-In for Excel. There are multiple macros and refs to SAS contents in the workbook, so it gets sometimes stuck on retrieving data. The user periodically kills his Excel process, but not a shared session process. So, the problem was in that Excel workbook with embedded SAS stored process, which took all the STP Server's resources.
... View more