Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Sep 2000 @ 22:53:51 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023