17.00 - 17.05 - Checking the Performance of an Upgrade - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

Monitor system behavior to make sure a Vantage 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 Services 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.