Find out a process making a table scan or cartesian product

[Jose7]

Hi experts,

I have sas installed on linux and sometimes I need to find out what process is filling the work area, whether due to bad programming or something else.
I go into Linux and run the top command to see the running processes, but I can't find a way to distinguish the process that may be causing the problem.

 

[SASKiwi · Accepted solution]

The way to do it is to analyse the SAS WORK storage area. Let's say your SAS Compute server uses a WORK storage area called /sas/saswork. Each SAS session creates a folder inside the saswork folder and they are named like this - tdnnnnn_<Server host name>_. The <nnnnn> part of the folder name is actually the process ID of the SAS session. So then you can easily find the WORK folder taking up the most space and identify the PID from the folder name using Unix commands.