How do you determine your system’s performance prior to the dreaded customer call asking why their queries are running longer?  What’s the impact to the business when the warehouse environment is under performing?

This presentation addresses best practices on performance testing and monitoring and the realistic actions that can be taken.  Performance baselines, benchmarks, workload queries, and canary queries are covered.  When/how to test are also described. Short term and long term ‘tune up’ performance ideas are given including capacity planning.

Note: This was a 2010 Partners Conference session, updated and re-recorded in 2014

Presenter: Jim Blair, Teradata Customer Briefing Team

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, Administrator, Data Warehouse Technical Specialist, Data Warehouse Project/Program Mgmt

Course number:49658
Training URL:
Format:Recorded webcast
Credit hours:1.00