07-13-2016 02:42 PM - edited 07-13-2016 02:50 PM
is there any SAS code or a way to get information or to know SAS performance (CPU utilization and more) from SAS EG or Base? We have many jobs running at same time and server performace going down over time. also, don't have sas admin access. Please help...
We are not using GRID either.
07-13-2016 03:35 PM
SAS Environment Manager provides this information in both SAS 9.3 and 9.4. Also operating system tools like Task Manager in Windows or third party tools like Perfmon also provide server monitoring capability.
Talk to your SAS administrator about getting access to Environment Manager.
07-14-2016 04:06 AM
additionaly to the great answer provided by @SASKiwi, which can give you statistics for performance at certain times, you can use the FULLSTIMER option to analyse performance on each of your SAS steps in the code: http://support.sas.com/rnd/scalability/tools/fullstim/
A sample result of a FULLSTIMER option UNIX output for a SAS Data Step is listed below:
NOTE: DATA statement used: real time 0.06 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds Memory 88k Page Faults 10 Page Reclaims 0 Page Swaps 0 Voluntary Context Switches 22 Involuntary Context Switches 0 Block Input Operations 10 Block Output Operations 12
07-15-2016 12:05 PM
In addition to the suggestions above, you may also want to consider ESM, a third party SAS performance tuning product that our company offers. It was built to solve the exact problem you describe.