Giant Increase in Load Times from Oracle DB

[titan31]

Ya, I've got the Cleanwork utility scripted to run and clear out anything in the workspace drive.

Will look into the processes part, it might make sense as after a full reboot, it goes fine.

For the loading, it's a batch load as it's scheduled to run at 1am each night, but even when we're trying it manually, it runs in a similar enough time. Some of the processes are a full reload and some are SCD loads. Differing jobs have different requirements there and nothing I can see that only sort of load is slowing down, it seems to be pretty uniform that everything just ends up tripling in time.

[AhmedAl_Attar]

Here is SAS paper you may want to look into for some ideas for performance boosting

- For Debugging Query Perfromance use the following SAS options   

OPTIONS SASTRACE=',,,d' SASTRACELOC=SASLOG NOSTSUFFIX;

There are more useful tips in the paper to look at,

Hope it helps,

Ahmed

[titan31]

Nothing seems to have worked so far anyway, still have same issue. One of our service partners thinks that installing all the latest hotfixes will solve the issue, but I can't see anything addressed by the hotfixes that looks like it would fix it.

[titan31 · Accepted solution]

Turns out it looks like it's McAfee and anti virus scanning that's causing it.

No idea how (yet), but just incase anyone else has this issue in the future.

[Kurt_Bremser]

Then you should consider switching to a real operating system (which does not need anti-virus software) for your SAS server. Or your complete server infrastructure as such.

[titan31]

Ya, I'm pushing for it for the next installation anyway (only in the role 2 months). 

Distributed environment and Viya seem to be Linux only anyway so any further upgrade of our infrastructure has to be that.