Archives of the TeradataForum
Message Posted: Wed, 02 Apr 2003 @ 18:49:14 GMT
Subj: | | Re: Pinpointing queries affecting performance |
|
From: | | Chris Coffing |
Is there a way to populate all queries sent to the warehouse into one table???
Does PMON have a command line or API that would capture all the queries into one table?
I know there are tools, if used, will consolidate the queries sent through using the particular tool but may not capture all of the
queries sent to Tdat.
The Accesslogging table may truncate large queries and the accesslog table is a hog with a bad index.... So, my question stands... Is
there a way to consolidate all the queries into a single table?
Thanks for your thoughts and comments. I understand the V2R5 will have this resolved for future use so maybe I should simply wait...
|