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
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.