Archives of the TeradataForum

Message Posted: Thu, 13 Sep 2001 @ 20:30:42 GMT

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

Hi All,

I'm looking for an easy way of reporting on how many active sessions are on my system on an hourly basis.

I currently run and report on, a canary or benchmark query. It's hourly elapsed time gives me a measurement of overall system response time. What I'd like to report on as well, is some measurement of how busy the system is - number of active sessions. A count from DBC.SessionInfo won't do - many of our users sign on and sit idle.

Ruth Fenwick

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