SAS Server processing is very slow and SAS I/O test are as follows:
I/O results are very unstable and EG data processing is also being affected. Currently, EG Query takes 6 hours to complete, earlier it was taking 2 hours (No change in SAS or Windows Environment. RAM >150 GB, Windows Server 2012 R2).
Can we get any clue to identify the slowness in performance or slowness?
Run your code (the most inefficient step) with
options fullstimer;
and post the log (use the {i} button).
Since you're on a toybox, think of cleaning up and defragmenting your filesystem(s).
From what I see in your screenshots you have a continuous breakdown of storage throughput from more than 1000 MB/sec to 600 MB/sec to 10 MB/sec. Get in touch with your server admins and have them see what's causing this.
Checking out SAS Environment Manager might help diagnose what is going on here too.
Our SAS 'toy box' (Windows Server 2012 R2 on VMware) provides very consistent run times.
Windows Server 2012 is not on VMware, its a physical machine. Where do we can check for proper I/O for SAS operations.
@ADS1308 - Like I said, SAS Environment Manager provides this type of information along with a lot of other useful stuff on CPU usage, memory usage, network performance etc. If you are not familiar with this, talk to your SAS Administrator.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.