 |
 |
Archives of the TeradataForum
Message Posted: Wed, 20 Sep 2000 @ 22:53:51 GMT
| Subj: | | Re: Access logging and utilities |
| |
| From: | | Sam Mosley |
We log all accesses against views (a multi-terabyte system with thousands of users), but copy to a rolling history table and purge
DBC access log daily. We keep the history for a week and then purge it. Prior to purging we summarize the access log into several
tables to determine accesses per view, who accessed which views, number of queries, number of queries per hour, etc. There is gold
in this data, and the performance penalty is not that high on most systems. Of course if you are taking hundreds of thousands of
user requests during the business day you would have to take that into account. Your system usage will determine how you should
proceed. (your mileage may vary) Tens of thousands of queries per day is not a problem if you aggregate and purge. You can actually
keep the sql for every query in a long term history table for quite a while. You will find many rows in access log per actual
request issued, so aggregating reduces the size greatly.
Sam Mosley
President VLDB Systems, Inc.
| |
