Archives of the TeradataForum
Message Posted: Sun, 23 Mar 2003 @ 18:21:28 GMT
| Subj: || || SUPER v2r5 Upgrade DBQ Log |
| From: || || Harold D Kleven |
While we're initially disappointed that very few of the metric columns are maintained in the DBQ tables, we've already found them useful
to helping a team examine their queries for performance chokepoints! By using only the basic Qlog table and the QStep table we can help
determine where the time is being spent. Yea, an EXPLAIN would help tell that, too, but when there's a dozen or so queries in a SP and the
developer didn't bother to parcel out the individual SQL and do an EXPLAIN, this helps track it down! And when the queries involve a lot of
Global Temporary Tables, which they are NOT collecting statistics on, this helps even more. Our THANKs to the folks for developing this...
now just provide the CPU and IO metrics, too!