Max User Query?

[former_SQLA_member1694868]

How would you figure out what how many users were ever logged in at the same time?

I am trying to come up with some testing scenarios for our software, and I know how many users there are total for a given site, and therefore how many possibly could be logged in at the same time. But I was wondering if there was a counter in the DB that I could query that kept track of how many actually ever were logged in at the same time historically.

[MCMartin]

You can have a look at the file sadiags.xml in this you find an entry maxconcurconn, as Mark stated: "...records the maximum concurrent client connections that was seen during the database server's up-time..."

see also question: Any documentation for sadiags.xml?

[VolkerBarth]

That's a nice hint - but how to analyze these numbers in the "maxconcurconn" node?

<F N="0" D="0" M="1,6,0,2,0,0,1,0,1,0,0,0,0,1,0,0,0,0,2,0,1" />
<F N="1" D="1,1" M="2,3,3,2,5,0,2,0,0,1,1,3,1,1,0,0,1,4,7,1,1,1,1" />

(Yes, my somewhat rash comment on your cited question - "self-documenting XML" - hits back...)

[MCMartin]

My understanding is, that N is the number of concurrent connections, but maybe Mark can give use more insight

[MarkCulp]

In the above two posted examples the N="0" and N="1" specify the maximum number of concurrent connections and the D-list and M-list of numbers refer to the number of times that that maximum was hit in the previous days and months respectively. Note that the days and months are relative to the date specified at the top of the file in the S tag. HTH

[VolkerBarth]

@Mark: Thanks for the clarification!

I should add, this excerpt is taken from a rarely-used test server on my box, and there were further entries with N > 1:)