Archives of the TeradataForum

Message Posted: Wed, 04 Dec 2002 @ 19:22:35 GMT

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

Stephen,

Yes, Query Log will record elapsed time, which tables and columns etc have been accessed and (with Teradata 5.1 I think) you'll also get usage figures per query. I don't know about additional functionality that Usage Tracker can give you.

Although there are limits of course, Query Log is very flexible and and you can tailor it to capture the sort of information that you require. Whether it's more/less efficient than using Usage Tracker I don't know and in truth I doubt that anyone has done any serious compaisons of the two as of yet.

As with all things there are Pro's and Cons to both.

-- Query Log comes as part of the Teradata dbms, wheras you have to pay for Usage Tracker separately.

-- Usage Tracker runs largely outside of the dbms (although par of it is on the same platform using cpu cycles) but I understand that you can load the data onto a different Teradata system. Query Log obviously uses cpu cycles on the same platform as your Teradata system is running on, you cannot change that.

-- Usage Tracker has pre-written reports and a reporting capability whereas the basic Query Log capability has none of that, you write your own. No doubt that will change over time.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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