Hi Dale
I run this query to see how many mounts and bytes for every drive :
select distinct(drive_name) as "Drive",count(*) as "# of
mounts",sum(bytes/1024/1024),sum(end_time-start_time) as "Total
Time",avg(end_time-start_time) as "Avg Time" -
from summary -
where activity='TAPE MOUNT' and -
start_time>=timestamp(current date - 2 day,'00:00:00') and -
start_time<=timestamp(current date - 2 day,'23:59:59') -
group by drive_name
Since it is from the summury table, I don't know how accurate it is since there
has been alot of problems with it recenlty. I still have nodes which report 0
bytes
transferred and I am at server 4.2.2.10.
Guillaume Gilbert
CGI Canada
"Jolliff, Dale" <xjolliff AT TI DOT COM>@VM.MARIST.EDU> on 2002-09-09 08:44:06
Veuillez répondre à "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Envoyé par : "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Pour : ADSM-L AT VM.MARIST DOT EDU
cc :
Objet : Re: 3494 Utilization
In the long run, we are attempting to quantify exactly how "busy" our
ATLs/drives are over time for a number of reasons -- capacity planning,
adjusting schedules to better utilize resources, and possibly even justify
the purchase of new tape drives.
At this point I have been asked to simply come up with a minutes or hours
per 24 hour period any particular drive is in use.
A "query mount" every minute might work, but it just isn't a good solution
for two reasons -- for clients writing directly to tape, the mounted tape
won't show up in "query mount", and most of these servers already have an
extensive number of scripts accessing them periodically for various
monitoring and reporting functions - I hesitate to add any more to them.
My last resort is going to be to extract the activity log once every 24
hours and examine the logs and match the mount/dismounts by drive and
attempt to calculate usage that way if there isn't something better. With
the difficulty in matching mounts to dismounts, I'm not entirely convinced
it's worth the trouble.
-----Original Message-----
From: Mr. Lindsay Morris [mailto:lmorris AT servergraph DOT com]
Sent: Friday, September 06, 2002 4:55 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: 3494 Utilization
If you use the atape device driver, you (supposedly) can turn on logging
within it. Then every dismount writes a record of how many bytes were
read/written during that mount.
Never tried it ... if you can get it working, let me know how, please! We'd
love to be able to do that.
Right now we CAN show you library-as-a-whole data rates, just by layering
all the tape-drive-writing tasks (migration, backup stgpool, backup DB, etc)
one atop the other minute by minute. Maybe that's enough - why do you need
drive-by-drive data rates?
---------------------------------
Mr. Lindsay Morris
CEO, Servergraph
www.servergraph.com
859-253-8000 ofc
425-988-8478 fax
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Jolliff, Dale
> Sent: Friday, September 06, 2002 2:16 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: 3494 Utilization
>
>
> Paul said that Servergraph has this functionality - According to our
> hardware guys, the 3494 library has some rudimentary mount statistics
> available.
>
> I'm going to be looking into both of those options.
>
> Surely someone has already invented this wheel when trying to justify more
> tape drives - other than pointing to the smoke coming from the drives and
> suggesting that they are slightly overused....
>
>
>
>
>
> -----Original Message-----
> From: Cook, Dwight E [mailto:DWIGHT.E.COOK AT SAIC DOT COM]
> Sent: Friday, September 06, 2002 6:45 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: 3494 Utilization
>
>
> Good question, never actually thought about it...
> I would think that the sum of the difference between mount &
> dismount times
> for each drive...
> OH THANKS..... now I won't be able to sleep until I code some select
> statement to do this :-(
> if I figure it out, I'll pass it along
>
> Dwight
>
>
>
> -----Original Message-----
> From: Jolliff, Dale [mailto:xjolliff AT TI DOT COM]
> Sent: Thursday, September 05, 2002 10:04 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: 3494 Utilization
>
>
> I saw this topic out on ADSM, and I could not locate any type of
> functional
> resolution ...
>
> What is everyone using to calculate the "wall time" of your tape drive
> utilization?
>
|
