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?
>
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Need help controlling explosive growth, Bob Brazner
- Re: Need help controlling explosive growth,
Mapes, Mark <=
- Re: Need help controlling explosive growth, Hilton Tina
- Re: Need help controlling explosive growth, Andrew Raibeck
- Need help controlling explosive growth, Bob Brazner
- Re: Need help controlling explosive growth, Dave Larimer
- Re: Need help controlling explosive growth, Andrew Raibeck
- Re: Need help controlling explosive growth, Keenan Stratton
- Re: Need help controlling explosive growth, Henning Pedersen
- Need help controlling explosive growth, ADSM : Dist Stor Manager [mailto:ADSM-L
|
|
|