Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Mar 2003 @ 01:41:51 GMT

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

Subj:   Re: Max Load Tasks
From:   Scott Gallagher

There is no optimal setting for all Teradata systems.

This is a parameter you'll need to adjust based on many factors such as

- Hardware Configuration
- Concurrent Process Requirements
- Service Level Objectives

Presuming you'd like to increase this value to achieve greater system utilization, or performance, or . . .

Consider adjusting this value upwards until you feel pain. Then, decrement and monitor.

For example, increment this value by one every day, week, or perhaps even month if you have concerns over significant month-end processing requirements.

Stay sensitive to your service-levels as you monitor Teradata for positive or negative feedback. If you begin to see negative feedback such as problematic system resource contention, then reduce this value and monitor.

Because this is an adjustable value and data warehouses are dynamic in nature, remember that you may need to increase or decrease this value as the data warehouse environment changes and grows.

Scott Gallagher, TCM

  <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: 28 Jun 2020