Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Mar 2006 @ 14:27:21 GMT


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


Subj:   Re: Disk Space overhead?
 
From:   OHara, Daniel

Hi Victor,

The original post was looking for database capacity. This is pretty straight forward but does not try to indicate what you can use this capacity for. The pricing document is adding a factor for the way the data is stored and what spare capacity is required for spool etc.

They are using a factor of 0.27 to go from Actual Data to disc capacity.

Eliminating the 0.5 for Raid 1 and .915 for OS Overhead they have used a factor of 0.6 to go from MaxPerm to User Data Capacity. This figure varies dependent on how the data is used. Factors to include:

Spool Requirements

Index Requirement

Fallback Overhead

Compression (this is to the good)


The 0.6 figure will be a typical figure avrived at by looking at systems in the field.

The different classes of data warehouse vary the storage per node to give different performance characteristics.


Daniel O'Hara
Project Manager
Teradata a Division of NCR



     
  <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: 15 Jun 2023