Performance Tuning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 40
- Joined: Sun Jan 21, 2007 1:52 pm
- Location: Chennai
- Contact:
Performance Tuning
I would like to know the different ways which are generally used for performance tuning of Server jobs. Kindly reply me in this regard.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
The key performance indicator in ETL is elapsed time. If you can get the data in - or out, as the case may be - within the allowed time window, with a safety margin, then your ETL is performing satisfactorily.
The strongest mechanism for tuning that performance, therefore, is expectation management. And education that:
The key performance indicator in ETL is elapsed time. If you can get the data in - or out, as the case may be - within the allowed time window, with a safety margin, then your ETL is performing satisfactorily.
The strongest mechanism for tuning that performance, therefore, is expectation management. And education that:
- correct is far more important than fast and that that is where you should concentrate your efforts
rows/sec is an almost entirely useless metric
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Performance Tuning
There are many thing you can do but it depends solely on your requirements. some of the points are as below.muruganr117 wrote:I would like to know the different ways which are generally used for performance tuning of Server jobs. Kindly reply me in this regard.
1) Supplying a sorted input to Aggregator stage
2) Enabling Cache for the hash file
3) Avoid using joins in the source query if you can replace it with hash file and look-up
4) If possible divide the extraction and loading process in a job into 2 different jobs by landing the data in intermediate seq. file and loading the target from the file.
SMB
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: