Archives of the TeradataForum

Message Posted: Thu, 14 Sep 2001 @ 16:42:58 GMT

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

Howard,

Ruth's original question was:

Assuming Ruth defines active as "doing work on the system", or more precisely, "consuming resources", I think John Hall answered that question pretty well.

I think your question is a tougher to answer. The only definitively accurate way to determine "active" sessions during the execution of another query is through PM/API (mentioned earlier by David Wellman), or some sort of custom coded scrapper of HUTCNS=type output. However, something to consider: if your "canary" query takes 10 seconds to run, when will you be looking at active sessions during that period? It may sound trivial, but in a mixed workload environment or on system with large numbers of concurrent users, many sessions can log on and or off in 10 seconds.

I think it would be helpful to get a better understanding of what it is you are trying to determine. With more details, maybe someone on the list could provide an approach that might meet your needs.

BTW, in re-reading this note, it could be read as sounding less than friendly. That's not the tone I was going, for but that's the problem with email.:-)

Regards,

Thomas F. Stanek
TFS Consulting

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