Checking the Performance of an Upgrade - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Database Administration

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
tgx1512080410608.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
ujp1472240543947
Product Category
Software
Teradata Vantage

Monitor system behavior to make sure a Teradata Database software upgrade is producing the expected performance increases, as follows:

  • 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 Customer 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.