09-30-2011 03:14 AM
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).
10-02-2011 02:19 AM
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:
This writtem for 9.1.3, but most of can be applied in later versions:
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.
10-10-2011 12:45 PM
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: