ADSM-L

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

2013-09-27 11:55:18
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:53:00 +0000
AFAIK, all that does is let the VE backup VSS snap also truncate the logs.
But won't help with the change rate.....

Thanks!
W

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

Remember that the 6.4 TDP for SQL Server is VE aware, or so I've read.

Just a thought,
Nick

On Friday, September 27, 2013, Prather, Wanda wrote:

> 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 
> <javascript:;>] On Behalf Of Hans Christian Riksheim
> Sent: Friday, September 27, 2013 6:53 AM
> To: ADSM-L AT VM.MARIST DOT EDU <javascript:;>
> 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<javascript:;>>
> wrote:
>
> > See that page and search for reporting enhancement :
> >
> > https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wi
> > ki 
> > /Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20
> > Vi
> > rtual%20Environments
> >
> >
> >
> > "Prather, Wanda" <Wanda.Prather AT icfi DOT com <javascript:;>> 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 <javascript:;>]
> > >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 <javascript:;>> 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 <javascript:;>
> > >> |  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é.
> >
>