My batch is completing late, the tactical queries show inconsistent response times, some applications show extreme variability in resource consumption, the canaries are hoarse!
Bad queries need to be fixed! We will explain why certain queries are bad and visualize how they impact Teradata performance. We will show how to find them, discuss most common mistakes, and give tips on how to fix them. Techniques to measure 'incoming traffic' from highly volatile applications will be discussed.

Bad queries need to be fixed! We will explain why certain queries are bad and visualize how they impact Teradata performance. We will review in detail the important data needed to support Performance Tuning, Workload Management and Capacity Planning. We'll discuss how to use that data to measure query performance and run through scenarios to turn that data into information you can use to solve some of the most common performance issues on any system.
 

Key Points

  • With all the performance data on my system, how should I log, store and maintain it?
  • How to relate system KPIs to workloads?
  • What are the best practices to identify the most common performance issues?

Note: This was a 2007 Partners Conference presentation, updated in 2010.

Presenter: Donna Becker, Director of the America’s Professional Services, Performance and Workload Management Center of Expertise - Teradata Corporation

This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.

Audience: Data Warehouse Architects , Data Warehouse Technical Specialists

Course number:37769
Training URL:http://www.teradata.com/t/ten/
Format:Recorded webcast
Price:$195.00
Credit hours:1.00