It is important to keep the Teradata database system running in optimal condition so it can be available at 100% capacity and cater to all the work in an optimal fashion. But sometimes a wrong user query or the concurrency of work increases and degrades system performance. DBA should be ready for this unexpected situation and should have tools of the trade ready to overcome this situation.
Teradata performance features and recommended practices are difficult to capture in one document.
The following recipes will guide you through setup processes and monitoring day-to-day performance. They will also help you to identify and act upon system problems, enabling database admins to identify the cause of poor performing queries quickly ...