Re: how many active session?
2002-10-16 08:17:52
Hi Matt
I hope I can help with this. It doesn't seem straightforward but one way
could be...;
select number as sessid,cast(start_time as TIME)as Start,cast(end_time as
TIME)as End from summary where activity='BACKUP' AND cast(start_time as
DATE)='2002-10-15'
This will give you all backup sessions and their start/end time for the date
10/15/2002, but not those that started, say 23:55 the 14th, end ended on the
15th. You might want to put additional checks on this to get all sessions
between a start and end-time on two following days.
Now, you would have to count the sessions according to start/end-times. I'm
sure someone on the list can find a more precise way to count concurrent
sessions within a time period.
Rgds.
Geirr G. Halvorsen
-----Original Message-----
From: MC Matt Cooper (2838) [mailto:Matt.Cooper AT AMGREETINGS DOT COM]
Sent: 16. oktober 2002 13:31
To: ADSM-L AT VM.MARIST DOT EDU
Subject: how many active session?
Does anyone know of a way to track the number of active sessions overnight.
I know you can schedule re-occurring QUERY SESSIONs and then count them. I
want to just get the number of active sessions say every 15, 30 or 60
minutes. I have to find the best place to move some backups but I don't
have way of tracking this.
Would that TSM MANGER product provide this?
Thanks
Matt
|
|
|