https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923928#M28348 <P>Without knowing anything about the hardware used and the install/upgrade process, it is hardly possible to say anything helpful.</P> Thu, 11 Apr 2024 06:18:54 GMT andreas_lds 2024-04-11T06:18:54Z https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923925#M28346 <P>Hello. After we upgraded SAS 9.2 to SAS 9.4 codes that needed 2 hours to be executed now takes 9 hours. This applies to <STRONG>all of our pcs</STRONG> were we have installed the SAS with its license. We've already excluded SAS from our antivirus. We are using&nbsp;SAS Foundation and not&nbsp;Enterprise. Any thoughts? We are facing a huge issue with this delays.</P><P><STRONG>&nbsp;</STRONG></P> Thu, 11 Apr 2024 05:30:29 GMT https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923925#M28346 Nafsika 2024-04-11T05:30:29Z https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923926#M28347 <P>This is highly likely some install &amp; config issue and will require much more detail than you can share publicly to get to the bottom of it.</P> <P>I recommend that you contact SAS Tech Support directly.</P> Thu, 11 Apr 2024 06:08:13 GMT https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923926#M28347 Patrick 2024-04-11T06:08:13Z https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923928#M28348 <P>Without knowing anything about the hardware used and the install/upgrade process, it is hardly possible to say anything helpful.</P> Thu, 11 Apr 2024 06:18:54 GMT https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923928#M28348 andreas_lds 2024-04-11T06:18:54Z https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923934#M28349 <P>1) Does your code uses indexes created by datastep/proc datasets in SQL queries?</P> <P>2) Does your code produces a lot of listings/figures?&nbsp;</P> <P>Bart</P> Thu, 11 Apr 2024 07:05:01 GMT https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923934#M28349 yabwon 2024-04-11T07:05:01Z https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923940#M28350 <P>Run your codes with</P> <PRE><CODE class=" language-sas">options fullstimer;</CODE></PRE> <P>set and look at the timing information of particularly long-running steps. Compare these with logs from the 9.2 setup. Once you find (a) step(s) with a dramatic difference, post the 9.4 log here.</P> <P>&nbsp;</P> <P>Since 9.2 is very old, what else did change? I suspect you installed new computers at the same time.</P> Thu, 11 Apr 2024 08:07:21 GMT https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923940#M28350 Kurt_Bremser 2024-04-11T08:07:21Z https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923941#M28351 <P>I moved this to the Administration &amp; Deployment community, as it has nothing to do with the working of the SAS Communities website.</P> Thu, 11 Apr 2024 08:11:39 GMT https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923941#M28351 Kurt_Bremser 2024-04-11T08:11:39Z https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923942#M28352 Thank you Thu, 11 Apr 2024 08:20:25 GMT https://communities.sas.com/t5/Administration-and-Deployment/Upgrading-from-9-2-to-9-4-codes-execute-really-slow/m-p/923942#M28352 Nafsika 2024-04-11T08:20:25Z