Operational Methods - Advanced SQL Engine - Teradata Database

To optimize performance and reduce the cost of resource usage logging on your system, Teradata recommends that you:

1. Use Summary Mode to reduce the number of rows inserted into the resource usage tables if Summary Mode data provides sufficient information for your needs.
2. Do not disable Active Row Filter Mode for the tables that it is by default enabled for (such as, the ResUsageSps table). Active Row Filter Mode limits the number of rows written to the database each logging period and minimizes the amount of system resources used.
3. Avoid unnecessarily using or exhausting available disk space by doing the following:
   • Never enable logging on tables that you do not intend to use.

     For example, logging only to the ResUsageSpma table provides a lot of useful information with a minimal operational load on the system.

   • Use the largest rates that provide enough detail information for your purposes.

     Generally, you should use a logging rate no smaller than 60. The default rate is 600.

     These values can be adjusted any time, regardless of whether the database system is busy. New values take effect as soon as the adjustment command is issued. (For example, with ctl, when you issue the WRITE command.)

4. Purge old data from the resource usage tables periodically.