Archives of the TeradataForum
Message Posted: Fri, 14 Sep 2001 @ 15:05:24 GMT
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|