Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I am discovering problems with "Hot
- Thread starter BillDHS
- Start date
PMON (part of TD manager, but also present on the Teradata demo cd) is a good place to start especially with R4 and R5 where you can see SQL being run. It has an AMP CPU Skew display on the sessions screen. Anything with a high value you can display the sql of and find your problem query - give it a try.
For a bit more detail - are all your queries using the same userid/account string? If not you can easily find out what's going on by looking at dbc.ampusage. It has a breakdown of IO and CPU usage by userid/accountstring by AMP.
Anything particularly skewed will be immediately obvious from a quick query.
Regards,
TeraOz
For a bit more detail - are all your queries using the same userid/account string? If not you can easily find out what's going on by looking at dbc.ampusage. It has a breakdown of IO and CPU usage by userid/accountstring by AMP.
Anything particularly skewed will be immediately obvious from a quick query.
Regards,
TeraOz
- Status
Similar threads
- Locked
- Question
- Locked
- Question