Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 19 Jan 2010 @ 13:44:26 GMT

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

Subj:   Re: Concurrent users calculation
From:   Geoffrey Rommel

  What is the easiest way to find out the number of concurrent users in the system?  

I hate to say this, but it depends on how you define "users".

If you want the total number of sessions, select count(*) from dbc.SessionInfo. If a FastLoad job with 10 sessions is running, it will be counted 10 times; if a user is logged on 3 sessions, he will be counted 3 times.

If you want the number of distinct user ID's, select distinct(username) from dbc.SessionInfo. You may wish to distinguish between "batch" user ID's and real people.

If you want to count only SQL sessions, select only rows with a Partition value of 'DBC/SQL'.

Sometimes people want to know the number of distinct "jobs", counting user sessions separately but counting a single FastLoad as one job. For this purpose, use the LogonSequenceNo: the user sessions will have an LSN of '00000000'xb, the load utilities a non-zero value.

  <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