ADSM-L

Re: Need help controlling explosive growth

1998-09-15 13:37:16
Subject: Re: Need help controlling explosive growth
From: "Mapes, Mark" <MWM4 AT PGE DOT COM>
Date: Tue, 15 Sep 1998 10:37:16 -0700
Well, I don't know about all files, but if you want to know about the tapes
per node, try this select:

select node_name,count(*) from volumeusage group by node_name


Mark Mapes
PG&E

> ----------
> From:         Bob Brazner[SMTP:Bob.Brazner AT JCI DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Tuesday, September 15, 1998 10:14 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Need help controlling explosive growth
>
> During our daily DRM process, we backup the storage pool to tape.  In
> the last two weeks, we've nearly doubled the number of tapes we
> generate.  How can we find out who are the big users?  I see no total
> usage stats maintained at the filespace level (too bad).  How do I write
> QUERY/SELECT on all files (which number in the hundreds of thousands),
> grouped by node, without it taking forever to compute?  Am I better off
> dumping the query output to disk and then using something like SAS to
> process?  Any ideas anyone?
>