 |
 |
Archives of the TeradataForum
Message Posted: Thu, 04 Sep 2003 @ 16:42:27 GMT
| Subj: | | Re: Query Logging |
| |
| From: | | Walter, Todd A |
Just to be complete: I said that Query Log (DBQL) in V2R5, set up to log the same things that were being logged before in the Access Log,
will be significantly cheaper. DBQL also has summary level logging which allows information to be captured about high frequency requests
without the cost of a log record per request.
There are options of Query Log that will log an extreme amount of detail, really useful for detailed examination of a new or problem
workload. It will be easy to cause DBQL to have a high impact on system performance by turning on the most detailed logging for a lot of
queries or high frequency requests.
| |
