Re: how many active session?
Another approach is to turn accounting on, and use those records to create the view. We had the same need, and wrote a Rexx program that daily reads those records and generates a timeline using a very basic text format of a bar graph showing exactly when each session was running. We reference this whenever we want to add new nodes, or occassionally revamp the entire schedule, since it shows where our "spikes" and "holes" are. -Original Message- From: "Mr. Lindsay Morris" <[EMAIL PROTECTED]> Sent: Thursday, October 17, 2002 9:17 AM To: VM.MARIST.EDU;.ADSM-L Subject: Re: how many active session? One way to do this is to take periodic "query session" readings and count them. A better way (ours) is to analyze the activity log for session-start and session-end messages (not as easy as it sounds, but do-able). This is better because: 1. It doesn't hammer your TSM server with queries 2. It sees all the fine detail of session activity. When a TSM schedule fires, you may have 50 nodes in session - but only for a minute. 60 seconds later 8 of them are done; two minutes later 25 of the are done. So there's a spike of activity that you'd miss, if you only took a reading once every five minuntes. What good is this detail? Well, when you look at a night's worth, you might see that there's a spike at 8PM, which is mostly done by 8:30. Then there's another spike at 10PM. But from 8:30 to 10:00 PM, nothing much is happening. So you can see that it might be smart to move your 10 PM job up to 8:30, and squeeze your backups into a smaller window. - Mr. Lindsay Morris Lead Architect, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@;VM.MARIST.EDU]On Behalf > Of Niklas Lundstrom > Sent: Thursday, October 17, 2002 2:42 AM > To: [EMAIL PROTECTED] > Subject: Re: how many active session? > > > Hello > > The TSM Manager can provide you with this and much more. There is a > free 30day trialversion to download at www.tsmmanager.com I think the > product is very good > > Regards > Niklas > > -Original Message- > From: MC Matt Cooper (2838) [mailto:Matt.Cooper@;AMGREETINGS.COM] > Sent: den 16 oktober 2002 13:31 > To: [EMAIL PROTECTED] > 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 >
Re: how many active session?
One way to do this is to take periodic "query session" readings and count them. A better way (ours) is to analyze the activity log for session-start and session-end messages (not as easy as it sounds, but do-able). This is better because: 1. It doesn't hammer your TSM server with queries 2. It sees all the fine detail of session activity. When a TSM schedule fires, you may have 50 nodes in session - but only for a minute. 60 seconds later 8 of them are done; two minutes later 25 of the are done. So there's a spike of activity that you'd miss, if you only took a reading once every five minuntes. What good is this detail? Well, when you look at a night's worth, you might see that there's a spike at 8PM, which is mostly done by 8:30. Then there's another spike at 10PM. But from 8:30 to 10:00 PM, nothing much is happening. So you can see that it might be smart to move your 10 PM job up to 8:30, and squeeze your backups into a smaller window. - Mr. Lindsay Morris Lead Architect, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@;VM.MARIST.EDU]On Behalf Of > Niklas Lundstrom > Sent: Thursday, October 17, 2002 2:42 AM > To: [EMAIL PROTECTED] > Subject: Re: how many active session? > > > Hello > > The TSM Manager can provide you with this and much more. There is a free > 30day trialversion to download at www.tsmmanager.com I think the > product is > very good > > Regards > Niklas > > -Original Message- > From: MC Matt Cooper (2838) [mailto:Matt.Cooper@;AMGREETINGS.COM] > Sent: den 16 oktober 2002 13:31 > To: [EMAIL PROTECTED] > 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 >
Re: how many active session?
Hello The TSM Manager can provide you with this and much more. There is a free 30day trialversion to download at www.tsmmanager.com I think the product is very good Regards Niklas -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: den 16 oktober 2002 13:31 To: [EMAIL PROTECTED] 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
Re: how many active session?
>Does anyone know of a way to track the number of active sessions >overnight. > Servergraph/TSM graphs this number. See http://www.servergraph.com . David Ehresman A satisfied customer
Re: how many active session?
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:[EMAIL PROTECTED]] Sent: 16. oktober 2002 13:31 To: [EMAIL PROTECTED] 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
Re: how many active session?
Have you tried scheduling "select count(*) from sessions" every 5 or 10 minutes? Todd -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 7:31 AM To: [EMAIL PROTECTED] 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 ** This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **
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