Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 14 Sep 2001 @ 15:05:24 GMT

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

Subj:   Re: Number of ACTIVE users
From:   Francesca Alfino


I am new to this list and apologize if I missed something. I am curious as to the goal of logging active users. I tried posting this yesterday... we'll see if it is successful today.

I started looking at Active users when I was trying to measure workload and do performance reporting. If you are trying to track workload by hour, I ended up doing something slightly different for a lot of reasons. I have started keeping a timestamp with CPU seconds used in a support table. The reason is that the active users (at least on Tdata Mgr) can be active for a variety of reasons and there is not clear cut way to identify why they are active. So if you are trying to measure workload, CPU seconds is a good way to do that. It is not part of resusage. I tried concurrent sessions and a number of other things to get a single measure of workload. I had been producing weekly performance charts and came to the conclusion that the workload measured by CPU seconds used is the best way to go over time because any given utility or sql is going to take the same number of CPU seconds no matter how busy or lightly loaded the system is...


  <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