17.10 - Message Encryption and Performance - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
zuy1472246340572

Message encryption is CPU intensive; more so for the QoPs that use stronger encryption keys. Depending on the application, the type of session, and the workload, message encryption may adversely impact system performance.

For tactical workloads, there will be negligible performance impact when message encryption is enabled.

For bulk data movement workloads such as Load, Export, Archive, Restore, etc., there may be significantly higher performance impact on throughput, elapsed time to complete the job, and CPU utilization.

However, the higher impact due to CPU utilization will likely be more pronounced on the Client ETL and/or BAR server, which typically has less CPU capacity than the Teradata Vantage server.