Take a look at www.tsmmanager.com this will do exactly what you want and in
a graphical format, you can download it and use the evaluation license to
get the info you need. To be honest after now using this for a couple of
months I can't see how anyone could do without it. It's especially good at
doing nice pretty reports for the management to get them off your back and
give them more paper to pass around in meetings ;)

       .............Rikk

-----Original Message-----
From: Jolliff, Dale [mailto:xjolliff AT TI DOT COM]
Sent: 09 September 2002 13:44
To: ADSM-L AT VM.MARIST DOT EDU
Subject: 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?
>


****************************************************************************************************
Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK
NOTICE: This message is intended only for use by the named addressee
and may contain privileged and/or confidential information.  If you are
not the named addressee you should not disseminate, copy or take any
action in reliance on it.  If you have received this message in error
please notify postmaster AT equitas.co DOT uk and delete the message and any
attachments accompanying it immediately.

Equitas reserve the right to monitor and/or record emails, (including the
contents thereof) sent and received via its network for any lawful business
purpose to the extent permitted by applicable law

Registered in England: Registered no. 3173352 Registered address above
****************************************************************************************************