Archives of the TeradataForum

Message Posted: Mon, 31 Aug 2003 @ 23:54:26 GMT

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

Hi all,

Have you thought about using SQL Assistant (aka Queryman)? More on that below.

Beware if you turn on ODBC tracing 2 things can be absolutely guaranteed to happen.

1) Your queries will now appear to run very slowly, and

2) Disk will start to be consumed at a great rate of notes.

When you enable ODBC tracing, an extremely large amount of data is recorded pretty much everything that happens when running a query. Unfortunately it doesn't appear to record any timestamps (at least not on my system), so this might not help.

Also, if you do turn on ODBC tracing make sure you turn it off again - I had one colleague that turned tracing on and forgot to turn it off. A few weeks later I happened to overhear him complaining about slow query performance and running out of disk space. Why? Because his PC was faithfully tracing every query he was running - despite the fact he had rebooted several times.

Another possibility is if you use SQL Assistant (aka. Queryman), the history window shows you Elapsed time, DBMS Time and Fetch time for each query that it has run.

The DBMS Time is basically the time it took for Teradata to run the query. The fetch time is the time it took to return the results to queryman. The Elapsed time is DBMS + Fetch time.

Hope this helps.

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