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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.