ADSM-L [Top] [All Lists]

## Re: Formula to calculate # tapes required

2001-02-16 15:32:13
 Subject: Re: Formula to calculate # tapes required George Lesho Fri, 16 Feb 2001 14:34:31 -0600
 ```That's a great beginning to figuring out how many tapes you will need. If your backup/archive schedules have not changed for a month... suggest doing: q actl begindate=-30 search=ANR1214 Take the amount of data copied from your primary tapepool to copy tapepool for each day and add it up and divide by 30 for both backups and archives. Then divide this amount of data by the average for all storage pools as computed by Wanda's SQL... this should be as accurate as any way of determining the amount of tapes required and then you should plus this amount up by suspected or anticipated growth. You could do this on a yearly basis to determine what the average growth rate of what is being backed up is and intelligently guess how many tapes to purchase (or how long it will take the developers to finish a software project ;-) George "Prather, Wanda" on 02/16/2001 02:01:11 PM Please respond to "ADSM: Dist Stor Manager" To: ADSM-L AT VM.MARIST DOT EDU cc: (bcc: George Lesho/Partners/AFC) Fax to: Subject: Re: Formula to calculate # tapes required I agree. Here is a query that will do it for you: select stgpool_name as stgpool, cast(mean(est_capacity_MB/1024) as decimal(5,2)) as gb_per_FULL_vol from volumes where status='FULL' group by stgpool_name ```
 Current Thread Re: Formula to calculate # tapes required, (continued) Re: Formula to calculate # tapes required, Re: Formula to calculate # tapes required, David Longo Re: Formula to calculate # tapes required, George Lesho Re: Formula to calculate # tapes required, Prather, Wanda Re: Formula to calculate # tapes required, Paul Zarnowski Re: Formula to calculate # tapes required, Joe Faracchio Re: Formula to calculate # tapes required, Joe Faracchio Re: Formula to calculate # tapes required, Glen Churchfield Re: Formula to calculate # tapes required, George Lesho Re: Formula to calculate # tapes required, Prather, Wanda Re: Formula to calculate # tapes required, George Lesho <= Re: Formula to calculate # tapes required, George Lesho