ADSM-L

Re: [ADSM-L] How to track transaction stats for TSMVE backups?

2013-09-27 11:43:21
Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups?
From: "Prather, Wanda" <Wanda.Prather AT ICFI DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 27 Sep 2013 15:42:07 +0000
In my case it appears to be DB related, lots of small (over 100) SQL DB's.  
With the combination of the DB's, plus the DBA's (reasonably) creating 
maintenance plans which write flat-file backups of the DB's onto the same VM's, 
with the VM's coming from wholesale P-to-V conversions.   Think the solution is 
moving the SQL DB's onto a couple of big dedicated SQL servers, but that's 
mostly for future implementations; gotta just live with the history we've 
inherited for now.  ... And I just stumbled onto an Oracle DB I didn't know was 
out there....  sigh.

W

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Hans Christian Riksheim
Sent: Friday, September 27, 2013 6:53 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups?

We also see a high change rate and we think the reason for that is the Windows 
pagefile. Some trickery to exclude that would be welcome but since this is 
block based I guess it is not possible.

Hans Chr.


On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon <erwann.simon AT free DOT fr> 
wrote:

> See that page and search for reporting enhancement :
>
> https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki
> /Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20Vi
> rtual%20Environments
>
>
>
> "Prather, Wanda" <Wanda.Prather AT icfi DOT com> a écrit :
> >DID NOT KNOW THAT!!!!!
> >
> >Thanks MUCH!!!
> >Should take care of it.
> >
> >-----Original Message-----
> >From: Erwann Simon [mailto:erwann.simon AT free DOT fr]
> >Sent: Thursday, September 26, 2013 2:00 PM
> >To: ADSM: Dist Stor Manager; Prather, Wanda
> >Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups?
> >
> >Hi Wanda,
> >
> >If your server is at 6.3.3 or higher, there's a new summary_extended 
> >table you can select against. See sub_entity column that reports the 
> >vmname, so you can distinguish by VM.
> >
> >Erwann
> >
> >
> >"Prather, Wanda" <Wanda.Prather AT ICFI DOT COM> a écrit :
> >>I'm getting about 3 TB per day of VE backups.
> >>Something isn't right, it's a much higher change rate than I expected.
> >>
> >>So I want to know how much each VM is sending every night, figure 
> >>out who the offenders are.
> >>I can get the occupancy from the filespace, but I'm interested in 
> >>transmission stats, not total storage.
> >>
> >>With > 200 VM's, digging it out of the dsmsched.log is non-trivial, 
> >>same for activity log.
> >>Summary table has info for the data mover node only, doesn't show 
> >>the VM name.
> >>
> >>Before I reinvent the wheel by writing a log parser, has anybody 
> >>found
> >
> >>a better way?
> >>Anybody submitted an RFE for this already?
> >>
> >>Thanks
> >>
> >>Wanda Prather  |  Senior Technical Specialist  |
> >Wanda.Prather AT icfi DOT com
> >> |  www.icfi.com
> >>ICF International  | 401 E. Pratt St, Suite 2214, Baltimore, MD 
> >>21202
> >|
> >>410.539.1135 (o)
> >
> >--
> >Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
>
> --
> Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
>