Hi Experts,
I am working on DI studio.
I am planning to reduse a job running time from 1 hour to 45 minutes.
could you please expalin me the process or please provide me the document for the same.
Here my question is:
Is there any performance tunning techniques. if yes Please provide any document on the same.?
How to reduse job running time from 60 mins to 45 mins as a generic(already created indexes).
Regards,
Venkatesh.
Sounds like a very specific tuning requirement you've got there
Well, there are almost as many techniques that are jobs. If you can tune SAS programs, you are likely to tune DI Studio jobs, you just want to do it in an integrated way with the standard transformations.
Here are a couple of papers:
http://support.sas.com/resources/papers/proceedings11/135-2011.pdf
This writtem for 9.1.3, but most of can be applied in later versions:
http://www2.sas.com/proceedings/forum2007/108-2007.pdf
Can just ad that in 9.2 and later, it's to look a performance statistics for job, each step is monitored and can be analyzed via tables/graphs. So it' easy to fins your bottlenecks.
Good luck!
/Linus
Venkatesh,
As a first step, it woudl be good if you could identify which step and the type of processing that is causing the slowdown, but I've provided some general advice below regardless.
The papers provided above are a good reference. As mentioned by Linus, the first thing to determine is which step in your job is consuming the most runtime. As mentioned, the performance graphs that are available as of DI Studio 4.2 can be of great help here. If you're using an earlier version (3.4), let me know and I can provide other adivice. These graphs can also help you to determine whether your job is I/O bound (waiting on disk reads/writes) or CPU bound. A few other general points to consider:
Thanks,
Tim Stearn
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.