TeraTeam UK Teradata DBA Definition
term: Teradata Manager
An essential tool for the Teradata DBA, allowing a window on Teradata performance. Useful used in Parallel with bespoke tools such and those created by TeraTeam UK Limited and Ward Analytics.
Some tasks that a Teradata Database Administrator (DBA) or system manager can perform with the associated Teradata Manager applications (shown in bold text) include:
- View the overall system performance (and drill down to identify problem areas) through a graphical user interface - Alert Viewer
- Monitor Teradata Database performance and perform related production control functions - PMON
- Monitor, identify, and abort sessions on the Teradata Database - Session Information
- Monitor usage of vprocs and run node usage macros - Resource History
- Compare performance history over different periods of time - Performance Data Analyzer
- Perform database administration tasks on the Teradata Database - Teradata Administrator (WinDDI)
- Run many of the Teradata Database console utilities from the Teradata Manager PC- Remote Console
- Create a log to determine whether an application mix is causing delays because of database lock contention - Locking Logger
