Performance Tuning in Teradata

  • Unique Paper ID: 142621
  • Volume: 2
  • Issue: 5
  • PageNo: 46-51
  • Abstract:
  • "Performance Tuning:- Increasing the System's Performance without making any hardware changes." Data is continuously increasing and most systems will respond to increased load with some degree of decreasing performance. A system's ability to accept higher load or to increase maximum load can be scaled up by inducing more nodes or by Improving hardware type, but the Question remains is it really What was required ? The most important question with the business will be if the change we are doing is really justified because adding additional hardware means additional cost to company and if Issue is not of Capacity/ Increasing Available CPU cycles that can be used adding more hardware will only increase the DWH cost for Organization. So the important thing becomes, if we are using the System resources in an Optimal way or something can be done to improve the performance without causing any additional cost to organization. Considering the Importance a lot of work has been done all over the world on DWH performance tuning, In this article we would like to share various approaches or Levels at which Performance Tuning can be done.

Cite This Article

  • ISSN: 2349-6002
  • Volume: 2
  • Issue: 5
  • PageNo: 46-51

Performance Tuning in Teradata

Related Articles