Archives of the TeradataForum

Message Posted: Thu, 02 Dec 1999 @ 04:18:35 GMT

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

G'Day

Something which has puzzled me; is there a way to monitor what a SQL query is doing?>

MLoad makes quite a bit of info available via Qrysessn, this is not true for standard SQL. As I write I have 2 user queries which have run for many hours longer than expected and I've no idea what they're doing.

A while back we had the DB go down due to a piece of BAD SQL. At the time Support was able to identify the EXACT piece of SQL which caused this. It'd great If one had access to this level of detail.

Thanks

Gavin

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