 |
 |
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!
| |
