We are facing a severe LAG in SAS Ent. Guide 8.1. The Server where it is deployed has around 34 GB RAM. The issue is not with Processing time but with lagging of the Application as a whole. For example – it takes time to start, it takes time to run a code even if the log shows the processing time is very less. I ran the same code in SAS Studio and in SAS EG. The processing time for both of them is same (as it is shown in the log) But SAS EG takes more than 5 minutes to run the whole code and generate the result even if it is showing 6.84 secs in the log. Where As SAS Studio generates the results in just 6 secs. SAS STUDIO LOG NOTE: The data set WORK.ABC has 88414 observations and 69 variables. NOTE: Compressing data set WORK.ABC decreased size by 98.69 percent. Compressed is 145 pages; un-compressed would require 11052 pages. NOTE: DATA statement used (Total process time): real time 6.86 seconds cpu time 6.81 seconds SAS EG LOG NOTE: The data set WORK.ABC has 88414 observations and 69 variables. NOTE: Compressing data set WORK.ABC decreased size by 98.69 percent. Compressed is 145 pages; un-compressed would require 11052 pages. NOTE: DATA statement used (Total process time): real time 6.84 seconds cpu time 6.86 seconds Along with this, we never faced so much lag in SAS EG in our previous versions, Even the Query Builders, are showing "Preparing Server….".
... View more