Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 26 May 2004 @ 13:53:35 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Performance Tuning Query
From:   keith.hammond


As I suspect you realise, this is a large topic and I do not believe there is a simple answer.

Below are just a few suggestions I hope will point you in the right direction.

I would suggest that the first thing you need to do is understand the workload you have running during the day.

This will indicate how you address the problem.

For example, have you got processes running than can be moved to run during the night?

Are you running out of CPU due to the volume of work, or are some queries executing bad plans, eg running unnecessary product joins and consuming unnecessary CPU?

Are some categories of queries more important than others? If so, PSF can help manage your workload.

If you are on V2R5 you could implement some of the features that may help, such as MVC and PPI - though implementation needs to be thought through as depending on where you use them they could consume more CPU.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019