BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
bnawrocki
Quartz | Level 8

My co-worker and I have similar Windows 7 PCs running SAS locally - we have similar amounts of free disk space and memory and CPUs.

 

However, when she runs a SAS program, it takes her computer 3 or 4 times longer to run it than when I run the same program. The SAS code accesses SAS datasets that reside on our network.

 

I've looked at Windows Task Manager, and her computer doesn't seem to be maxing out on CPU or Memory when she is running the SAS code. I know how to read the SAS log to show "CPU"  time and "Real" time used by each SAS code step. Her CPU time is similar, but Real time is much, much higher.

 

Any ideas how to troubleshoot this issue? 

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

Some obvious things to check.

How busy is the machine doing other things? They could be taking CPU cycles, using memory, moving the disk head away from where SAS needs to read and/or write.

Are you using remote or local disks?  If remote how fast is the connection to the disk.  If local how optimized is the disk?  perhaps the data being read is fragmented on one disk and contiguous on the other.  Similarly for writing is there contiguous space to write the data or does the disk head need to jump around.

How similar are the machines really? Are the CPUs specs really the same? Are the disks really the same? Is the memory speed really the same?

View solution in original post

1 REPLY 1
Tom
Super User Tom
Super User

Some obvious things to check.

How busy is the machine doing other things? They could be taking CPU cycles, using memory, moving the disk head away from where SAS needs to read and/or write.

Are you using remote or local disks?  If remote how fast is the connection to the disk.  If local how optimized is the disk?  perhaps the data being read is fragmented on one disk and contiguous on the other.  Similarly for writing is there contiguous space to write the data or does the disk head need to jump around.

How similar are the machines really? Are the CPUs specs really the same? Are the disks really the same? Is the memory speed really the same?

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 445 views
  • 0 likes
  • 2 in conversation