Archives of the TeradataForum
Message Posted: Tue, 19 Jan 2010 @ 13:44:26 GMT
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.
|