Archives of the TeradataForum
Message Posted: Thu, 02 Dec 1999 @ 04:18:35 GMT
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.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023