BookmarkSubscribeRSS Feed
ADS1308
Calcite | Level 5

SAS Server processing is very slow and SAS I/O test are as follows: 

 

Untitled.png

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? 

5 REPLIES 5
Kurt_Bremser
Super User

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).

Kurt_Bremser
Super User

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.

SASKiwi
PROC Star

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.

ADS1308
Calcite | Level 5

Windows Server 2012 is not on VMware, its a physical machine. Where do we can check for proper I/O for SAS operations.  

SASKiwi
PROC Star

@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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1709 views
  • 0 likes
  • 3 in conversation