|
|
|
Junior Member
 
Group: Forum Members
Last Login: 11/1/2009 1:22:16 PM
Posts: 15,
Visits: 77
|
|
Hi ,
Which tool we can use to do performance tuning in Teradata.
As PMON is used to just view the query and to check the status of that query.
Regards,
kiran
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/10/2009 6:25:29 AM
Posts: 16,
Visits: 74
|
|
I am also new to Teradata, but not performance management in general.
Can you elaborate on what you are looking to tune?
You could tune queries, which would involve looking at the access paths, data distrubution, Primary Keys and Primary indexes etc
you could look at tuning the System in general, Memory allocations CPU, number of Amps/PE et al.
There does not seem to be the wealth of information on the internet about Teradata, that does not originate from Teradata, as you would find with Oracle or DB2, and there are only a few books on Teradata on Amazon etc which are old.
I found the following books on Teradatas site to be helpful.
Resource Usage Macros and Tables.
Teradata RDBMS Performance Optimization
Performance management.
They gave me a good start, but I may have been starting from a different position.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/6/2009 5:19:36 PM
Posts: 2,
Visits: 2
|
|
|
This is a huge topic that cannot be answered quickly. There are several Orange Books and Teradata classes that will help. Some of the Orange Books include topics on indexes (PPI and non-PPI), Tuning Tactical Queries, and many others. Orange Books can be downloaded from Teradata @ Your Service (contact your site administrator or DBA if you don't have access to T@YS). To tune queries, you need a solid understanding of the basics, including primary and secondary indexes (how to choose and how to use), database/table design, statistics, and joining tables. Spend a lot of time in the Teradata documentation (your DBA or site administrator should be able to help you install this on your computer). I don't have my list of classes that Teradata offers, but there are several that will help to gain enough understanding to tune queries. Last, but not least, use EXPLAIN to see how your queries will be run. Good luck!
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/12/2009 12:36:40 PM
Posts: 3,
Visits: 9
|
|
can any body tell me how PPIs will help in performance?
Grimm is here
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 7/15/2009 4:14:38 AM
Posts: 13,
Visits: 69
|
|
can some one point me the right URL for Teradata @ Your Service?
so that i can download this Orange Book
|
|
|
|