08-24-2016 03:02 PM - last edited on 08-24-2016 04:27 PM by Reeza
I"m new to the SAS Platform. I've recently been brought on to be a Platform Administrator. I've been tasked with troubleshooting 2 problems with our SAS deployment as of right now.
One is, our E-Miner platform has been running slow, giving us green check marks as everything is ok, rejecting data, and not giving any output.
Our other problem is, when running scheduled jobs overnight in EG, some the same jobs processing the same data has started to run 2-3 hours longer.
What are some steps I can take to start resolving these issues?
08-24-2016 03:09 PM
08-24-2016 03:52 PM
Thank you for the short SAS log that gives me the output from thestatements I had you add to the EM project.
There are lots of LIBNAME statements to Oracle. Are the steps that are running slow (which are not included in the SAS log you sent) accessing any of these libraries? If so, your slowness may be coming from extracting data from Oracle.
Again, a SAS log showing the steps that are running slower is needed.
08-25-2016 09:28 AM
There didn't seem to be anything in the code related to EM, albeit it's long and I may have missed something.
If you're running this on EM maybe you can move it to a full SAS installation to see if it's faster.
08-25-2016 11:07 AM
There seems to be some IO performance issues with two different directories that you are using. SAS WORK which is pointing to e;\WORK and TT which is pointing to \\aacadasas\cada. Can you give me more details on what type of storage each of these file systems are pointing to?
Also, why do you have MEMSIZE equal to 75GB? That is really high.
08-25-2016 12:37 PM
SAS WORK and aacadasas/dada are on the same drive just a different path.
I'm not sure about MEMSIZE. Is that set per program or is it a default in the SAS config? What would you recommend it being set to?