The following table describes set up tasks that must be completed to use the performance management techniques described elsewhere in this Appendix.
|Resource Usage Data (ResUsage)||Turn on ResUsage data collectors to enable system data gathering and provide information to various Teradata Viewpoint system management portlets.
In addition to Teradata Viewpoint, you can use ResUsage macros to examine the collected data.
For information, see Resource Usage Macros and Tables.
|Lock Logging||Use the WITH LOCK =n log option for the BEGIN/REPLACE QUERY LOGGING statement to log any lock contention longer than n centiseconds. The minimum acceptable value for n is 5.
You can access the DBQL lock log through the Viewpoint lock viewer portlet or query the system table DBC.DBQLXMLLOCKTbl or the view DBC.QrylockLogXMLV.
For information, see Periodic Maintenance and Performance.
|Teradata Viewpoint||Configure Teradata Viewpoint, the primary Teradata Database system management tool, to:
For details, see the Teradata Viewpoint User Guide.
|Space allocation||Allocate space according to best practice recommendations, including a spool space reserve. See:
|Collect Statistics||Collect statistics on table columns and recollect when necessary to provide the Optimizer with the information necessary to create optimal query execution plans.|
|Database Query Logging (DBQL)||Set up DBQL to collect data about queries for use in query optimization and detection of bad queries. See:|
For information on other useful tools, see Troubleshooting: Operational DBAs.