16.10 - Checking Performance when Upgrading - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

When upgrading the Teradata Database software, you should monitor system behavior to make sure the upgrade is producing the expected performance increases.

  • Recollect statistics for the existing configuration if they are not current.
  • Create a baseline test suite.
  • Run the baseline on the system before the upgrade.
  • Save the EXPLAINs for the base queries.
  • Run the test bed again after the upgrade, and get new EXPLAINs.
  • Compare the two EXPLAINS.
  • Check for faster/slower response on any of the test queries. If slower, look at the before and after EXPLAIN.Check the statistics.
    • If stale, recollect.
    • If not, report this as a performance regression problem to Teradata Support immediately.

Performing these simple activities, even with a small group of queries (5-10 minimum are recommended), will help validate your performance results and expectations following any sort of important system change.