topic Re: SAS server performance in Administration and Deployment

SAS server performance

woo — Wed, 13 Jul 2016 18:50:35 GMT

Hello Friends,

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.

Thank You

Re: SAS server performance

SASKiwi — Wed, 13 Jul 2016 19:35:13 GMT

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.

Re: SAS server performance

JuanS_OCS — Thu, 14 Jul 2016 08:06:17 GMT

Hi @woo,

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

Re: SAS server performance

woo — Thu, 14 Jul 2016 15:49:24 GMT

Thank you Juan and SAS KIWI...

Re: SAS server performance

boemskats — Fri, 15 Jul 2016 16:05:28 GMT

Hi Woo,

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.

Nik

Re: SAS server performance

woo — Fri, 15 Jul 2016 18:17:47 GMT

Thnak You boemskats, will look into your site for more details.

Re: SAS server performance

error_prone — Tue, 19 Jul 2016 22:02:50 GMT

The admin should have a look at http://support.sas.com/kb/51/660.html or http://support.sas.com/kb/51/659.html to ensure that the data throughput is high enough.