https://communities.sas.com/t5/SAS-Programming/Find-out-a-process-making-a-table-scan-or-cartesian-product/m-p/930331#M366022 <P>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_&lt;Server host name&gt;_. The &lt;nnnnn&gt; 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.&nbsp;&nbsp;</P> Thu, 30 May 2024 20:04:25 GMT SASKiwi 2024-05-30T20:04:25Z https://communities.sas.com/t5/SAS-Programming/Find-out-a-process-making-a-table-scan-or-cartesian-product/m-p/930323#M366018 <P>Hi experts,</P> <P>&nbsp;</P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción" aria-label="Texto traducido" data-ved="2ahUKEwi_x6n1_rWGAxXLfjABHfHuAIoQ3ewLegQICBAU"><SPAN class="Y2IQFc">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.</SPAN></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura.JPG" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/96875i226F5DFCDA1F3EAA/image-size/medium?v=v2&amp;px=400" role="button" title="Captura.JPG" alt="Captura.JPG" /></span></P> <P> </P> <P>&nbsp;</P> Thu, 30 May 2024 18:26:31 GMT https://communities.sas.com/t5/SAS-Programming/Find-out-a-process-making-a-table-scan-or-cartesian-product/m-p/930323#M366018 Jose7 2024-05-30T18:26:31Z https://communities.sas.com/t5/SAS-Programming/Find-out-a-process-making-a-table-scan-or-cartesian-product/m-p/930331#M366022 <P>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_&lt;Server host name&gt;_. The &lt;nnnnn&gt; 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.&nbsp;&nbsp;</P> Thu, 30 May 2024 20:04:25 GMT https://communities.sas.com/t5/SAS-Programming/Find-out-a-process-making-a-table-scan-or-cartesian-product/m-p/930331#M366022 SASKiwi 2024-05-30T20:04:25Z