 |
 |
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.
| |
