When do you need a fire brigade most? When your house is on fire!
When is the best time to establish the fire brigade?
No, not when your house is on fire, but before the city the house is located in is founded.
Finally, when should there be a fire safety inspection?
Before and while you construct and dwell the building, not after the fact, when entire wings have to be torn down and reconstructed.
The same is valid for performance specialists and Data Warehouses.
The Teradata Tuning Specialist
Performance Specialists are a good fit for your Data Warehouse team at the inception of a data warehouse project and any later stage.
This is not lobbying, but insight from years of experience in Data Warehousing.
When you think that engaging such a specialist is too costly before you can justify his or her presence with pressing real-life problems, you are essentially saying that you are willing to drive the probability of a project fail up.
Hasty project starts are costly at exponential rates!
Many design and implementation decisions have immediate and often far-reaching effects on how smooth or cumbersome it will become to operate the data warehouse.
Data warehouse team members will and should be focused on other issues such as database administration, the business model behind all the data, financial aspects of the projects, SQL development, load job scheduling, etc.
The Performance Specialist looks ahead and in between to identify bottlenecks and Tsunamis before they hit you.
Sunk cost and wrong turn prevention are worth a dollar on the dime!
A project member with such an explicit focus can co-determine where the entire project will be covered one year from now: On page 1 of the corporation’s success story magazine or at the project funeral service announcement pages.
It is of vital importance both to you and your clients that there is a common understanding of the strategic dimension of a performance tuning endeavor before any debate over measurements and results takes place.
There are always the following strategic goals of Performance Optimization:
- A net improvement of system resource usage is achieved.
- Key stakeholders of the Data Warehouse can achieve their goals at all, or again, or faster, or more regularly, and with less friction and intervention.
- Changes and improvements are sustainable in terms of time, staff, and irrespective of Performance Specialists’ presence.
Where and how this improvement is achieved is a matter of the problems at hand and the constraints under which one operates. Still, there is no meaningful improvement claim without any demonstration that a quantifiable, intentional change took place.
Performance work is goal-oriented. Therefore, a finite set of measures can only be claimed as a performance success if it solved a problem that was there in the first place.
Improvement can only be called such if its effects are not short-lived or a mere shift of trouble from one end of the Data Warehouse to the next and if they last irrespective of how operates the Data Warehouse at the moment.