Performance Tuning in Teradata

Performance Tuning in Teradata
Author(s):
Mahesh Khaire, Jasmeet Singh Birgi, Sahil Hira
Keywords:
DWH , Performance Turing , Teradata
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.
Article Details
Unique Paper ID: 142621 Publication Volume & Issue: Volume 2, Issue 5 Page(s): 46 - 51
Article Preview & Download

Share This Article

NCSST-2021

AICTE Sponsored National Conference on Smart Systems and Technologies

Last Date: 25th November 2021

LATEST INNOVATION’S AND FUTURE TRENDS IN MANAGEMENT

Last Date: 7th November 2021