Checking the Performance of an Upgrade - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

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