Performance Tuning - Report for analysis

Database
Enthusiast

Performance Tuning - Report for analysis

Hi,

In Oracle 10g, there are AWR and ADDM Reports.
1. AWR Report : It consolidates the information regarding TOP SQLs, All Database Configurations,.... which will be helpful to find the bottlenecks
2. ADDM Report : Provides recommendations to rectify the problems in Database based on AWR Report.

Is there similar kind of stuff in Teradata, to :
1. Identify bottlenecks
2. Recommendations to solve those problems

Thanks.

With Regards,
Raja.
4 REPLIES
Enthusiast

Re: Performance Tuning - Report for analysis

RAJA,

when oracle can give you that then why not TEARDATA. :)

well i dont know how gud is your understanding on teradata but then answer to your question:

You can make use of DBQL,AMPUSAGE to understand query and session level details
You can make use of RESUSAGE* tables to understand system wide performance

Teradata has customised took like Performance database capacity reporting PDCR ( V12) / PMCP ( V6) to give u the whole pic in the best format through charts.

u have index wizards and stats wizards for query recommendation. You have VISUAL explain tool to compare explains of the query,
U have SET tool to simulate ur prod data in test and lots of gud stuffs........

regards
Teradata_DBA
Enthusiast

Re: Performance Tuning - Report for analysis

Where can i find the documents related to PDCR, PMCP, TPERF reports :

a. How to install these reports

b. How to generate these reports

c. How to interpret the report

Enthusiast

Re: Performance Tuning - Report for analysis

Tssr,

Generally those are available as part of a performance tuning engagement provided by the Performance COE @ Teradata.

Cheers

Enthusiast

Re: Performance Tuning - Report for analysis

wont we have access to any of these... because if COE is involved everytime for performance issues, that would make it costly for the client!!!