15.10 - Collection and Logging Rates - Teradata Database

Teradata Database Application Programming Reference

Teradata Database
Programming Reference

You can control the rate at which resources are monitored (collected) and, if you enable resource logging, the interval at which a data row is to be inserted into the log table.

Setting Collection Rates

The following collection rates can be set:

  • Global session monitoring
  • Local session monitoring
  • Resource monitoring
  • For more information on these types of rates, see “Data Collection” on page 39.

    Setting Logging Rates

    You can enable logging of collected data into the resource usage tables. In this case, you also set a logging rate that specifies how often a data row is to be inserted.

    Logging is not required to collect and retrieve current data, but it does preserve data that would otherwise be lost at the next collection interval.

    If you decide to enable logging, set the logging rate. The resource logging rate, also referred to as the physical or virtual resource logging rate, sets the interval in seconds at which resource usage data is written to the resource usage tables (see “Data Collection” on page 39). The rate is saved on disk every time it is altered. Use the SET RESOURCE RATE request to set this rate (see “SET RESOURCE RATE” on page 205).

    The resource logging rate:

  • Can be set within the range of 0 and 3600 seconds.
  • With a value of zero indicates that logging is not being performed.
  • Returns the value ResLogging in the MONITOR PHYSICAL SUMMARY and MONITOR VIRTUAL SUMMARY requests.
  • Note: A physical resource logging rate is the same as a virtual resource logging rate.